How to update SQL Server table using DTS

[wondemh]

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

 

[foxdev]

Henock, in editing the existing DTS package that you already created, you should have to options to either A) transfer a table, or B) import based on a Select statement. Choosing B would allow you to enter the SQL statement, including any necessary filtering, that pulls only the data you want. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com