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.
| Author |
Topic |
|
vyelchri
Starting Member
12 Posts |
 Posted - 2009-11-23 : 03:57:00
|
| Hi,we have some files (files count will vary based on the day) in FTP location. we want to load each file data into a table in SQL Server database using SSIS package FTP task.Can some body please assist me how to create a package?Thank you,Venu YelchriThanks,VB |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-23 : 09:44:48
|
| you can use ftp task to get files onto your folder. then use for each loop to loop through files and use dataflow task to transfer data using flat file source and oledb destination to get data onto table. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-23 : 09:52:55
|
| http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx |
|
|
|
|
|
|
Load Remote files data into SQL Server Database