I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS

[fhadlaq]

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.

[Roel Schreurs]

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

fh*****@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.

[Feras]

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

fh*****@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.