none
How to import data to an excel from a secure website using SSIS

    Question

  • Hi,

    I want to import data from a secure website (where i am giving my id and password),to an excel using SSIS.

    Please Help.

    Thanks in advance.

     

    Wednesday, June 23, 2010 6:30 AM

All replies

  • This will have to be a two stage process, first download the file, then import it as normal.

    Here are two methods fr downloading a file. The first one uses the HTTP connection manager, so the credentials would be set on there, but the second does it all in code.

    Downloading a file over HTTP the SSIS way

    HTTP Authenticatoin Download of File in SSIS to CSV file
    http://www.sqlis.com | http://www.konesans.com
    Wednesday, June 23, 2010 7:17 AM
  • Hi Darren,

    Thanks for your immediate reply :)

    I am new to SSIS.I will check with these to links and update you.

    --neesa

     

     

    Wednesday, June 23, 2010 7:22 AM
  • Hi Darren,

    I tried the first method.I created httpconnection manager but while click on test connection,it show a message like Unable to connect to remote server.I dont know how to attach a screenshot here.Please help.

     

    Wednesday, June 23, 2010 7:47 AM
  • Sounds like something is wrong, perhaps start by testing the URL in a browser on that machine.
    http://www.sqlis.com | http://www.konesans.com
    Friday, June 25, 2010 9:33 AM