dbTalk Databases Forums  

DTS SQL Server To Oracle problems.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS SQL Server To Oracle problems. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fernando M. Lopes
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.