>Hi all,
>
>I need to update my SQL Server 2000 tables with rows from an Oracle table. Using a DTS package, how can I get only rows from the Oracle table that have a date value greater than the maximum date from the SQL Server table?
>
>Thanks
>
>Henok

Two ways that may work for you:

1) Get the Oracle table into a temporary table in the SQL database and run the query there. The drawback is that you have to bring in all records from the Oracle table.

2) Write a distributed query by using OPENROWSET(). It would accept a regular OLEDB connection string to connect to your Oracle database. Additional parameters accept the SQL statement to be run. This will only bring the required rows but it takes a little longer to process, depending on the number of rows on the table.

HTH