469,271 Members | 1,081 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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

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.

Jul 23 '05 #1
2 4625
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.

Jul 23 '05 #2
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.


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Damon Grieves | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.