Link to home
Start Free TrialLog in
Avatar of vdr1620
vdr1620Flag for United States of America

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
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Avatar of vdr1620

ASKER

Reza,

I was using a similar script using VB.Net.. I have also tried this without any luck
SOLUTION
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vdr1620

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

and also for the code you tried before and got error, did you trusted certificate for https ?
Avatar of vdr1620

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..??
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad to solve,
Regards,