Hi,

I am a newbie at sql server. Can someone please tell me if there is anyway
to only import data from source database that aren't already existed in a
table of the destination database?

Thanks.

Donna

One method is to use DTS Data Driven Query tasks, but they are slow. I
suggest you use the much simpler T-SQL queries to work that out. I have an
example here at:
http://vyaskn.tripod.com/sql_server_..._practices.htm

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Donna" <dmak0 (AT) yahoo (DOT) ca> wrote

Hi,

I am a newbie at sql server. Can someone please tell me if there is anyway
to only import data from source database that aren't already existed in a
table of the destination database?

Thanks.

Donna