By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,971 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,971 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.