Split CSV file based on first column value changes and load into destination table in SSIS?

511 views Asked by At

I have Import.csv file,

First column values --> table names which are already exists in target database.

Next two columns [Desc],[Code] data gets populate from CSV file to table.

TABLE_NAME  DESC    CODE
tab1       table1   A
tab1       table1   B
tab1       table1   C
tab2       table2   D
tab2       table2   E
tab2       table2   G...

In this scenario, how to load tab1 data into the same table in destination and so on.

Which way will be more standard to accomplish this task? If its a script task using C#, kindly give me a clear script to identify a value changes in the first column.

0

There are 0 answers