Oracle to SQL Server via DTS
Posted on 2004-08-04
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