lundi 29 juin 2015

Load multiple Excel files into multiple SQL database tables using SSIS

I need to load multiple individual Excel files into multiple SQL tables in the same database using SSIS.

I have 61 files need to loaded into 61 tables in the same SQL database.

I created tables in SQL database.

I created SSIS project for Data Flow Task, Foreach loop container specification , Variables for connectivity as the picture below.

enter image description here

Data Flow control has:

enter image description here

Excel Source:

enter image description here

OLE DB Destination:

enter image description here

The problem is this way read all the files in the folder but add it to one table in the database.

I need to add each file to his independent table in the SQL database.

Thanks for helping.

Aucun commentaire:

Enregistrer un commentaire