Wednesday, March 21, 2012

DTS Copy Columns

I am using a DTS to copy columns from one database to another.
How do I do the same thing, but first check if the data alreday exists in the destination table and then only copy if it doesn't exist?
thanks in Advance
ActionAntIN your transformation

Move your data using a query that will return only what to insert.

No comments:

Post a Comment