Hi,

I try to setup the data transfer package from DBIII to SQL2000.

How can I setup the DTS package tansfer only the new data daily?

Thanks,

You will need to be able to identify the new data. You can then use
that as criteria in a query as the source to the DataPump task.

Can you identify new data?

You may be able to use a linked server

"Dannie Chan" <DannieChan (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,
Thank ou for your reply,

The new data with p_orderno field (number)incresae but not by 1 some skip
more.
Would you explain more about the link server?

Thanks

Dannie

"Allan Mitchell" wrote:

Easiest way to explain linked server is if you look at this in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acdata.chm::/ac_8_md_06_8tf7.htm

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acdata.chm::/ac_8_qd_12_9ooj.htm



"Dannie Chan" <DannieChan (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

Thanks for your information.

Dannie

"Allan Mitchell" wrote: