Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marvypx
Starting Member
1 Post |
 Posted - 2009-11-03 : 15:34:01
|
| Hi i recently created a DTS that moves some date from sql server to oracle.i created two connections :i)connection 1(sql server)i)connection 2(oracle)---OLE DBthe steps created are :1) truncate an oracle temporary table2) transform data from sql server into an oracle temporary table3)update a oracle table based on values from the temp table4) flag the sql server records that went across to oraclei recently read that based on the DTS settings on the following tabs (PACKAGE-->PROPERTIES-->ADVANCE) and (PACKAGE-->PROPERTIES-->lOGGING)a DTS can rollback when a transaction step fails.i still have a one questions: will it rollback inserts/updates made to a oracle table if a step fails ? i really would appreciate any assistance regarding this question.thanks much. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-04 : 13:04:17
|
| only if Oracle is configured to participate in a distributed transaction |
 |
|
|
|
|
|
DTS transactions (rollback,commit)