Posted by mike_kilby@hotmail.com on 10/04/86 11:52

Hi,

I am trying to set up a DTS Package to transfer data from a remote
MySQL server to a local MS SQL database. The source tables will remain
static as will the destination however I only want to copy down data
that does not already exist in the local database.

I have two different methods of which to identify the new rows, on some
tables it is by a unique ID thus in TSQL I would say WHERE ID > x.
Other tables are by date where I would want to do something like WHERE
CreateDate >= GetDate()-1

How would I go about performing such clauses using DTS?

Thanks

Mike

• Next in forum: Smarter Table build - might split the table
• Prev in forum: Re: Make and save a blob on the fly in stored proc
• Thread view: Newby DTS Question

[Reply to this message]