Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

Oracle to SQL Server via DTS

Dear All,

Can anyone point me to an article on the NET to explain to me briefly how to use DTS to suck (filtered) data out of Oracle tables into a preset SQL table I'll want to use for reporting?

Ideally, I'd like to save the package to run daily, weekly or on demand, and preferably in two version, one as complete rebuild, and one as a differential copying only those records which have been changed since the last copy, ro new records, or deleting deleted records!!!

Thanks in anticipation
DAVE THE RAVE
davesm@freeuk.com
0
davetheravesmith
Asked:
davetheravesmith
  • 2
  • 2
1 Solution
 
arbertCommented:
Frist, close some of your really old questions...

check out http://www.sqldts.com

I think by far the easiest, is to just right click on your sql database and choose "Import Data".  The wizard will walk you through setting up the initial package.  You save it at the end, then you can schedule it and manipulate it to do what you need.

Brett
0
 
pkohlmilCommented:
I think you want to try:
www.sqldts.com    and
www.sqlmag.com
Both have useful information. Otherwise, it would be helpful to know what problems you are having.
0
 
davetheravesmithAuthor Commented:
Basically, the source database is in a bit of a state, I expect to have rpoblems with NULLs and DATE transforms.  It's Oracle to SQL but I'll check out your advice, and thanks

DAVE S
0
 
arbertCommented:
Not even a split--Guess I should have posted a few more links without any direction....
0
 
davetheravesmithAuthor Commented:
Er soory, I didn't realise you could SPLIT points, thanks anyway - DS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now