HI all, I need to test weather i can open a website or not( which has all the.csv files i need to get into my packagE) so now i want test site in 3 ways Try the following: - First try using the internet explorer - Then try using ftp - Then try using HTTP task in SSIS 2008 !st one is ok ..i could open it how to test ther two..can anyone please let me know....i think last one is HTTp connection manager. Thanks in advance Jyo

you can download one of the files with FTP task to test its functionality. But about HTTP, there is no HTTP Task, but there is http connection manager, In your case it is better to use Script task and write .net codes to check the http connection to that web address. and my question is : why you ran these checks? you want to download those files from the web address, if they are under ftp, you can use FTP Task for them, if they are under a http address, then you can write script task to download files from http, this is a sample of second one: http://blogs.msdn.com/b/benjones/archive/2009/03/29/using-a-c-script-task-in-ssis-to-download-a-file-over-http.aspx if each of those operations failed, you can use fail precedence constraint to find out that task failed , so what is requirement for checking them first?!http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Here are two examples of downloading a file from a website: http://microsoft-ssis.blogspot.com/2011/05/download-source-file-from-website-with.html And there are third party tools such as CozyRoc or BlueSSIS which you can use for downloading.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Thanks for your replay...Actually 2 days back we had project proposal so everyday they post .csv files in their site i need to create a package to import them automatically..now i just want to test that site by using the above 3 ways... try with ftp means...is it enough if i replace https://.............com with ftp://..........com? i tried it but not working for me...when i opened with IE (https:..com) its working but with ftp://...com its giving an error...

for using FTP you need to have ftp available on the website. In your case there is no need to test with FTP, just follow the link In my first post or what SSISJoost posted to download files from http, you can put try catch and other validations on the .net code also to check if connection to http could establish or not.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com