DTS with multiple files (merge)
Posted on 2003-02-25
I am using DTS to import from CSV files into a table on MS SQL doing some transformations on the way.
My problem is that I would need to import data from different files that are matched row to row but with different fields.
FieldA FieldB FieldC Col1 Col2 Col3
FieldA FieldB FieldZ Col4 Col5 Col7
What I would like to do is process everything in parallel. Basically the two files are opened (same number of rows)and data is merged into the table row by row.
However DTS processes things sequentially so I have rows that are totally mismatched. Any suggestion/workaround greatly appreciated...