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 |
|
mushy
Starting Member
12 Posts |
 Posted - 2010-01-22 : 09:30:38
|
| Hi Gurus,I am newbie in SSIS, i have a import folder with few text files(different structures), i need to loop and pick up the text files and insert each text file into different table. if i use for each loop container to loop through files,how can i define for specific text file insert into a specific table ?Thanks Guys. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-22 : 10:10:16
|
You can add the FILENAME property and add a "Conditional split" to split at the filename column.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-23 : 07:33:08
|
| do you mean metadata of files will vary? |
|
|
|
|
|
|
Flat Files into different tables.