Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    7

    Question Unanswered: Help with DTS Packets

    I am having a problem working this DTS packet. I have a local database table that takes in data and at a certain time of the day I have a DTS packet to run and insert into a remote SQL server. I have no problem running the DTS packet, but it is inserting duplicate data into the remote SQL server. How would I go about checking to see if the data already exits on the remote SQL server? Any help would be greatly appreciated.

    Thanks,

    Corey

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    one option,
    first u insert into another table in remote server, then u compare ur records with original table.
    delete duplicates from temp table
    insert from temp table to ur orignal table.
    truncate temp table.
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

Posting Permissions

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