Importing HTTP file using SSIS?

• David Finnegan-403714

  SSChasing Mays

  Points: 602

  More actions

  April 30, 2007 at 10:27 am

  #116577

  Hi,

   

  I am just wondering whether anyone has any experience of how I would import a .csv file from a website. The site is actually https, but I can open the file using https://username:password@www.site.com/

   

  I can download the file to a local folder and import it without any problems. However I need to download the same file every day, though it's name changes depending on the date. So I am just wondering whether there is a way to do it using SSIS?

   

  Many thanks

  David

• Jim C-203340

  SSCommitted

  Points: 1716

  More actions

  October 17, 2007 at 3:50 pm

  #742906

  Hi David,

  Did you ever find a resolution for this? I'm faced with the same issue.

  Any help would be appreciated!

  Thanks,

  Jim

  Regards, Jim C

• Frank Shen

  SSC Journeyman

  Points: 89

  More actions

  October 18, 2007 at 2:59 pm

  #743305

  Check this out, pretty good document

  Using SQL Server Integration Services (SSIS) to import an Excel file from a SharePoint Document Library (or other HTTP location)

• Jim C-203340

  SSCommitted

  Points: 1716

  More actions

  October 18, 2007 at 3:08 pm

  #743307

  Thanks Frank.

  There are 2 other posts i've found regarding this that helped me reach a solution.

  http://sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

  http://sqlblogcasts.com/blogs/greenmtnsun/archive/2007/09/06/http-authenticatoin-download-of-file-in-ssis-to-csv-file.aspx

  Regards, Jim C

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 24, 2015 at 2:23 am

  #1841958

  HI Am also having the same requirment.

  I tried to follow the steps you have specified but didnt worked.

  Its giving error . "late bound resolution for dts".

  Can you please share the proper code. Am using VS2010

  Regards,

  Ravi