Incremental Update in DTS

  • Hi,

    I m transferring data from source DB Table to Destination DB table on a weekly basis... as of now i m transferring all the data from source to destination every time, this takes time to transfer the data.  Any simple way to update the records based on unique key if records is already exists else insert the record.

    Thanks in advance.

    Regards ~ Kodi

  • Use the Data Transformation object in your DTS package and use an ActiveX script to first check for the existance of the row based on the unique key, if it does not exist, insert it.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply