MANY txt (csv) files... I need to import them in bulk. 1

[03Explorer]

I have 52 text files that I need to import into a single table. It appears each file has the header of column names as first row. Is there a way to use SSIS to gather the file names from the directory and import them? It will be a new table. The server is SQL Server 2008. Each TXT file is proximately 17.6MB file (52 files = 2.32GB)


I know how to setup a basic SSIS package to import from a file into a table, but I want to take it up a notch and have the package do all TXT files.

 

[Alan0568]

Yes. The 'foreach loop container' is ideal for this used with a Foreach File enumerator.

http://msdn.microsoft.com/en-us/library/ms141724.aspx

 

[SQLScholar]

good article here showing you how.

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------