CODEWITHSUNDEEP
sql-server-2008ssis
vbNewbie
vbNewbie

Reputation: 3345

importing thousands of files in a flat file manager SSIS data flow task sql server 2008

I am trying to import multiple tab delimited files into a sql server table using a SSIS package. I set the flat file source and created a flat file connection manager but I was told I will need to create multiple flat file sources for this. This cannot be true right? Is there not someway I can use a loop and the source folder directory location?

Upvotes: 1

Views: 1902

Answers (2)

Neil
Neil

Reputation: 919

Here is a link that shows how to do this: http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

I like the layout and the graphical indicators used on that page.

Upvotes: 0

Meff
Meff

Reputation: 5999

So long as the files are all the same structure, you'd use a for-each loop, of type file. Point it at the folder with the files in, and assign a variable to the file+path. Then use that variable as an expression on the flat file connection manager.

Upvotes: 4

Related Questions