Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  transfer ONLY new records from Oracle into SQL ser

Author  Topic  speed Starting Member 1 Post Posted - 2004-03-30 : 11:18:42 Subject : Transfer ONLY new records from Oracle into SQL server Hi All, I need a little help here.. I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS. How should I go about it? a) how do I use global variable to get max date. Where and what DTS task should I use to complete the job? Data Driven Query? Transform data task? How ? can u give me samples. Perhaps you can email me the Demo Package as well. b) so far, what I did was, - I have datemodified field in my Oracle table so that I can compare with datelastrun of my DTS package to get new records - records in Oracle having datemodified >Max(datelastrun), and transfer to SQL Server table. Now, I am stuck as to where should I proceed - how can I transfer this records? Hope u can give me some lights. Thank you in advance. __________________ -speed-smy-wanie-