Error in TransactionOption in SSIS

Hi,

I was trying to maintain transactions between my tasks, so I set the TransactionOption property as Required to the Parent Container (For Each Loop Container). But I am getting the following error while executing my SSIS package.

"Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running."

I checked in my Windows Services and did not find MSDTC. Pls let me know if you have any solution for this.

Thanks in advance.

Regards,

Prakash Srinivasan.

Look for "Distributed Transaction Coordinator" and start it.|||

Hi,

Sorry I found this already and started. But I am facing an other issue like If I set the TransactionOption as "Required" to my Parent Conatiner, I am getting the below mentioned error in the Connection Manager.

[Execute SQL Task] Error: Failed to acquire connection "SQLConnectionMgr1". Connection may not be configured correctly or you may not have the right permissions on this connection.

But if I set the TransactionOption as "Supported" then it is working fine. Pls let me know if you have any idea or solution.

Thanks & Regards,

Prakash Srinivasan.

|||You are not getting the error message when you set the TransactionOption to "Supported" because the container does not start a transaction, but joins any transaction started by its parent container. However, if you set it to "Required", the container starts a transaction, unless one is already started by its parent container.

Your problem is related to starting a transaction in your connection, I think. This could be attributed to the DTC properties. You may want to read about DTC in detail and set its properties based on your need.