Hi,

I hope someone can help.

I have a dts package in SQL Server 2000 with 2 connections. table A in
database 1, table A in database 2. Basically I want to update table A
in db1 with the data in db2 because db2 is more recent.

I want to pick the max date (from the date field) from table A db1 and
then extract all records from table A in db2 where the date is greater.

I am planning to use a lookup query but I am not sure this is the right
solution.

Hope this is clear.

Thanks in advance for any help,

Loic

Try this package design, no lookups required-

1 Exec SQL Task to query max data from db1..A, store result in global
variable
2 DataPump task of source select * from db2..A where datefield > ?, and set
the input parameter to the global variable from above. Set destination as
db1..A

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

<loic_nospam (AT) yahoo (DOT) com> wrote