How to load Multiple different structured CSV files into one table using SSIS?

225 Views Asked by At

I am trying to load a set of different structured CSV files into a single table using SSIS.

I don't want to create a connection for each CSV file.

Can anyone suggest how to load a different set of structured CSV files into single table.

For Example, Patterns like

Source

ClientDet.csv --> Id, First Name, Last Name & ClientPlan.csv -->Id, Plan Type, Plan Date

Destination

dbo.ClientPlanDetails --> ID, Client Name, Plan Type, Plan Date

1

There are 1 best solutions below

3
On

Assuming all the source files have the same format, You should use a for each loop container