Hi
We have 3 CSV files exactly the same format which I need to get into a SQL table (same table)
Trex.CSV
Samples.csv
Literature.csv
SQL table is called Samples
I have created a package that runs ok with just one file Trex.csv and this will update ok into the SQL table.
However I cannot find away to add the other 2 CSV files so it can run in one package.
Is this possible and if so how please.
Thanks
We have 3 CSV files exactly the same format which I need to get into a SQL table (same table)
Trex.CSV
Samples.csv
Literature.csv
SQL table is called Samples
I have created a package that runs ok with just one file Trex.csv and this will update ok into the SQL table.
However I cannot find away to add the other 2 CSV files so it can run in one package.
Is this possible and if so how please.
Thanks