Hi,

I'm creating a DTS package here that is supposed to import data from an
Oracle (9iR2) database into a SQL server database. I have it working fine
so far using the Microsoft ODBC driver for Oracle (had some problems using
the OleDB driver as it seemed to not recognize the ? parameters).
Now I want to put a transaction around it to ensure data integrity.
However, now I'm getting error messages telling me (sorry, translated from
German) something like "Connection ... doesn't support distributed
transactions or failed joining. Registration in transaction not possible"

Am I missing something?

Thanks!
Jens