I am pretty new at DTS and I need to move data from one table to another. There is no data transformations but there are quite a few look tables to get the corresponding data on the Destination table and creating new records in other tables.
The move from one Source table to about 4 Destination Tables in the same DB.
I also log transfer exceptions into a table.
Currently I have an ActiveX task that gets the table and passes row by row (ADO) to a stored procedure to do all the inserts, updates and error logging.
Not sure if this is the best task to use..
Any Help would be greatly appreciated.