DTS SQL Server To Oracle problems. -
03-01-2004
, 05:50 AM
Hello ALL.
I´m doing a DTS to send data from SQl Server tables to Oraacle tables.
Well, I do this. The data transference works right.
But, how I will be certain that the data had been really transferred?
I try use transaction, but it´s not work with different databases (I
guess...)
I transfer data from 3 different tables, and if the transference of any
table of them cause error, the process all must be stopped.
Somebody already made something similar or has some idea to help me?
Thanks in advance and sorry my English.
Fernando Lopes |