Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: 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
    ActionAnt

  2. #2
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    IN your transformation

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •