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

    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.



  2. #2
    Join Date
    Jun 2003

    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.


Posting Permissions

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