Link to home
Start Free TrialLog in
Avatar of davetheravesmith
davetheravesmith

asked on

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
Avatar of arbert
arbert

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
ASKER CERTIFIED SOLUTION
Avatar of pkohlmil
pkohlmil

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davetheravesmith

ASKER

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
Not even a split--Guess I should have posted a few more links without any direction....
Er soory, I didn't realise you could SPLIT points, thanks anyway - DS