Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Import CSV via http in SSIS

Author  Topic 

scromer
Starting Member

6 Posts

Posted - 2012-02-15 : 14:36:46
I need to periodically download csv files via http and dump them into a SQL Server 2008 table. How can this be accomplished using SSIS? I have searched google extensively but found very little on the subject.

Thanks,
Sam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-15 : 15:00:47
see

http://www.sqlis.com/sqlis/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

scromer
Starting Member

6 Posts

Posted - 2012-02-15 : 16:38:47
Thanks for the info!
Go to Top of Page
   

- Advertisement -