Download Files from HTTPS using SSIS

vdr1620
vdr1620 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Reza,

I was using a similar script using VB.Net.. I have also tried this without any luck
Reza RadConsultant, Trainer

Commented:
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Author

Commented:
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>
   
Reza RadConsultant, Trainer

Commented:
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

Reza RadConsultant, Trainer

Commented:
and also for the code you tried before and got error, did you trusted certificate for https ?

Author

Commented:
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..??
Commented:
Hey Reza,.. I have solved the issue.. the Old Activex script i had seems to work now,after adding the link to the trusted connections list in IE

Thanks for the help
Reza RadConsultant, Trainer

Commented:
Glad to solve,
Regards,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial