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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-08 : 09:17:21
|
| Aser writes "Hello,I am using SQL Server 7.0. Using DTS I am creating a package which will export table data from SQL Server tables to Oracle tables. The table structures in both databases is identical.What I want to do is use transactions. If any problem arises and the data from particular table cannot be inserted to oracle table, then I want the entire transaction to rollback.I am enabled the Use Transaction option for the DTS package. Also for the steps I have checked on Join Transaction. I am using Microsoft OLE DB Provider for Oracle. However when I execute the package I get the following error."Task 1 does not support distributed transactions oR failed to join"I have tried using Oracle Provide for ODBC as well as Microsoft ODBC driver for Oracle with the same error.Can any one suggest whats wrong? Is there any other way to rollback?And using SQL Server 7 is a pre requisite.Any help will be appritiated,RegardsAser" |
|
|
|
|
|
DTS -SQL Server exporting data to Oracle