Using DTS between Oracle Tables Error---Help!!!!

[sewarker]

Hello. We have a DTS package that transfers information between two Oracle tables. The packages runs successfully if we execute our commit and rollback transactions after each DTS step. However, when we have a single commit or rollback for the entire package, we receive the following error when attempting a transfer:

does not support joining distributed transactions or failed when attempting to join. (Microsoft OLE DB Provider for ODBC Drivers (8004d00a): [Microsoft][ODBC driver for Oracle]Driver not capable)

Any help is greatly appreciated.

Steve

 

[mrdenny]

Oracle handles things much differently that SQL Server. If you are moving data from one Oracle DB to another Oracle DB why are you using DTS? Why not move the data using the Oracle ETL tool (seperate purchase) or straight through a linked server from one database to another?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[EdwinGene]

You need to start the MS Distributed Transaction Coordinator. It's under the Support Services folder (which is at the same level as the Databases folder) in the Explorer tree on the left side of your Enterprise Manager window.