I want to transfer ONLY new records AND update any modified records from Oracle into SQL S

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 these
records?

Hope u can give me some lights. Thank you in advance.Hi,

Should could start trying the DTS Import wizard. You can start it form
the SQL Server Enterprise Manager. Select the Databases node in the
console window. Choose All tasks | Import data from the context menu. In
one of the steps you can choose to write a query to select the data. In
another step, you can choose to save the wizards action into a new
package. Later, you van view and modify the package. It is found in Data
Transformation Services node in the console window.

Allthough there may be a far better way to get a max date value, you
might consider storing the value in a settings table in the Oracle
schema, so you can include in in you queries.

Good luck,

Roel Schreurs

fhadlaq@.yahoo.com schreef:
> 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 these
> records?
> Hope u can give me some lights. Thank you in advance.|||hi Roel ,
thank you for ur reply , i have created a DTS Package and and filled it
with queries and stuff :) , it is working fine now , thanks again :)
Roel Schreurs wrote:
> Hi,
> Should could start trying the DTS Import wizard. You can start it
form
> the SQL Server Enterprise Manager. Select the Databases node in the
> console window. Choose All tasks | Import data from the context menu.
In
> one of the steps you can choose to write a query to select the data.
In
> another step, you can choose to save the wizards action into a new
> package. Later, you van view and modify the package. It is found in
Data
> Transformation Services node in the console window.
> Allthough there may be a far better way to get a max date value, you
> might consider storing the value in a settings table in the Oracle
> schema, so you can include in in you queries.
> Good luck,
> Roel Schreurs
> fhadlaq@.yahoo.com schreef:
> > 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
these
> > records?
> > Hope u can give me some lights. Thank you in advance.sql