Post reply

Check for new data in a DTS package

  • April 5, 2004 at 8:07 am

    #66003

    Hello everyone,

    I've been creating DTS packages for about 5 months now and was wondering how to do the following:

    When a package is created, say for instance your copying data from a source to destination, than you decide to check for new data in the source and you only want to copy the new data into the destination, how would you do that using DTS?

    Any information would be greatly appreciated.

    Thank you,

    Peter

    Peter M. Florenzano

    Database Administrator

  • April 5, 2004 at 9:04 am

    #501768

    Import the data into a worktable then run a join to check for the new data and then insert what's new.


    Shamless self promotion - read my blog http://sirsql.net

  • April 5, 2004 at 9:15 am

    #501771

    Thank you for your response stacenic, I will give it a try!

    Peter M. Florenzano

    Database Administrator

  • April 7, 2004 at 2:39 am

    #501965

    I have to do this between two servers on a very slow line and one of the servers (Destination) uses 6.5. (Source =2000). I'm just about to go on a long period of reseach..Any hints?

Viewing 4 posts - 1 through 3 (of 3 total)

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