How to use transaction in a SSIS Package

I try ton use a transaction in a SSIS package. When running i have an error :

[source [1]] Error: The AcquireConnection method call to the connection manager "myconnection" failed with error code 0xC0202009.

[Connection manager "myconnection"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 "Le partenaire du gestionnaire de transactions a dsactiv la prise en charge des transactions à distance/par rseau.".

Can someone help ?

thanks

Where is that 'myconnection' connection manager pointing to?

Make sure you open it an test its connection.

|||The connection is pointing an oracle database and is correct. When i run tha package whitout the transaction it works correctly. This error appears only when i implement the transaction.|||I believe SSIS uses Microsoft's Distributed Transaction Coordinator - Oracle needs to have support for that enabled explicitly (or at least it did last time I used it).|||I try to do the same thing using SQL SERVER 2005 databases for source and destination. And i have the same error.|||

Make sure you have Distributed Transaction Coordinator running on both the source and destination machines.

Brian Knight has a good video about it on Jumpstart TV - Using Transactions in SSIS

|||

Try to use checkpoints too!

Regards

|||

PedroCGD wrote:

Try to use checkpoints too!

Regards

Not the same as transactions though...|||

I know is not the same..

but could help... some people dont know checkpoint and it features.