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 |
|
mailme180181
Starting Member
3 Posts |
 Posted - 2009-06-18 : 09:06:56
|
| I want to read existing files from folder and transfer the data in sql server with the help of SSIS packages.After reading the files i should not read them again next time so i need to put them in some other folder.I have created pkg with FlatFile Source and OLE DB Destination which is working fine but i need to specify the file path everytime manually. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-18 : 14:36:48
|
| http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx |
 |
|
|
|
|
|
Reading flat files from folder into sql server