jpn
jpn

Reputation: 43

How to load Flat files to SQL Server Tables according to the Name of Flat File?

There are hundreds of flat files

how to achieve this in SSIS.

Ps: i am beginner to all of this.

Upvotes: 0

Views: 90

Answers (1)

Srikar mogaliraju
Srikar mogaliraju

Reputation: 215

Try using Dynamic SQL in a Script task. For each file(use for-each loop container) get the header and file name to create a table and then insert the data into that table using Dynamic SQL.

This should be your last option.

If all the files are .xlsx you can do this using ExecuteSQL Task.

Upvotes: 1

Related Questions