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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
DAVE S
Not even a split--Guess I should have posted a few more links without any direction....
ASKER
Er soory, I didn't realise you could SPLIT points, thanks anyway - DS
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