Every morning we need to go to an external website, log in with a username and password and download a zip file that is then unzipped as a sql server 2008 database. Because of server traffic someone has to come in before 8AM to start the download. Is there a way to use SSIS to automate a download over HTTP? Thanks!

If you can script it (and it is possible) then yes. You just add a script task to the Control Flow in which you need to reference the appropriate libraries. Here is sample code: http://www.vbdotnetheaven.com/Uploadfile/mahesh/DownloadWebPage04252005073432AM/DownloadWebPage.aspx To unzip you can use Execute Process Task linked to after the Script Task Besides, your post is of discussion type. Arthur My Blog

Hello, please have a look http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx Thankshttp://sqlage.blogspot.com/