vdr1620
asked on
Download Files from HTTPS using SSIS
Hi Guys,
I am trying to download Files from secure HTTP using SSIS.. Either using ActiveX or Script Component... I was previously using Activex and Script Component in different situations to download the files from HTTP site but now I have to get them from HTTPS.. Can any one plz help me out ?
Thanks
I am trying to download Files from secure HTTP using SSIS.. Either using ActiveX or Script Component... I was previously using Activex and Script Component in different situations to download the files from HTTP site but now I have to get them from HTTPS.. Can any one plz help me out ?
Thanks
ASKER
Reza,
I was using a similar script using VB.Net.. I have also tried this without any luck
I was using a similar script using VB.Net.. I have also tried this without any luck
OK,
I didn't tried this one, but it seems to work with HTTPS:
http://geekswithblogs.net/MrWright/archive/2009/09/04/csharp-https-file-download.aspx
I didn't tried this one, but it seems to work with HTTPS:
http://geekswithblogs.net/MrWright/archive/2009/09/04/csharp-https-file-download.aspx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i have tried this to.. It succeeds but doesn't download the data ..instead loads the error message to the File
Error:
<form method="post" action="https://xxxx.mgmt.slb.net/SingleSignOn/SignIn.aspx?SsoProductCode=sa&SsoRedirectUrl=/xxxxx/Admin/xxxxxCSV.aspx?cli_sid=1">
<input type="hidden" name="TestCookieCreated" value="1" />
</form>
Error:
<form method="post" action="https://xxxx.mgmt.slb.net/SingleSignOn/SignIn.aspx?SsoProductCode=sa&SsoRedirectUrl=/xxxxx/Admin/xxxxxCSV.aspx?cli_sid=1">
<input type="hidden" name="TestCookieCreated" value="1" />
</form>
OK, I haven't test HTTPS to check if these code works or not, so forgive me if I direct you to wrong codes.
As I read in this article you can use HTTPS too, this also used HttpWebRequest for handle this. could you try this one :
http://www.codeproject.com/KB/IP/DownloadDemo.aspx
As I read in this article you can use HTTPS too, this also used HttpWebRequest for handle this. could you try this one :
http://www.codeproject.com/KB/IP/DownloadDemo.aspx
and also for the code you tried before and got error, did you trusted certificate for https ?
ASKER
I don't think there is a problem with the certificate because i don't see any problems downloading the file from the browser.. it has anonymous access.. i have tried using a Http link also and it returns a similar message.. I am not familiar with scripting so unable to figure out the exact problem ..
i have not tried the download demo link yet.. is there any other way that you can think of..??
i have not tried the download demo link yet.. is there any other way that you can think of..??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to solve,
Regards,
Regards,
http://blogs.msdn.com/b/benjones/archive/2009/03/29/using-a-c-script-task-in-ssis-to-download-a-file-over-http.aspx