Best Task to use: Table to Table transfer

Last Post 15 Dec 2006 10:01 AM by JHunter. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

14 Dec 2006 12:14 PM

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.

New Member
New Member

15 Dec 2006 10:01 AM
I'd use a OLE source, use the transform task (column copy) to write the data to a flat file (or files). Then you can bulk load the files into your destination tables (and you have an audit trail by way of the file - if you want it).

In DTS I'd use execute task (with stored procedures) to clean up the data.


Acceptable Use Policy