Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS zipped file over https

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2010-04-01 : 06:00:00
Morning all,
Any help here would be great, am trying to download a zipped file from a https page. So far I have used this solution to get me going.
http://sqlblogcasts.com/blogs/greenmtnsun/archive/2007/09/06/http-authenticatoin-download-of-file-in-ssis-to-csv-file.aspx
But it works in that it does download the file and saves it to my desired location, but it can’t unzip the file. When I check the size of the file downloaded and the size of the file on the https page they are totally different. The file downloaded from my SSIS package is nearly double in size. Now when I download the file straight from the https location it opens up perfectly.
Thanks in advance
Lemondash
   

- Advertisement -