transfer ONLY new records from Oracle into SQL Server using DTS

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 datelastrun.

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-