October 9, 2009 at 7:57 am
Hi, I am new to SSIS and was wondering if anyone could help me.
I have a folder containing a number of text files which I need to import into the same SQL Server table. I know how to import one file but not sure on how to import all files that are in the folder at once.
Any help would be much appreciated.
Cheers
October 9, 2009 at 8:03 am
You can use the For Each Loop container to loop through the directory.
Put the data flow that reads the file into the container, on the container properties select the directory and and file type that contains your files.
October 9, 2009 at 10:29 am
Charlotte, I wrote an article on this topic recently - hopefully this will help:
http://www.sqlservercentral.com/articles/SSIS/68025/
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
October 12, 2009 at 11:41 am
Cheers for the help guys!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply