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.