I have a SSIS package (2008) that has a sequence container with TransactionOption Required. This is needed to ensure that multiple tasks commit or fail together. It also has a custom transformation that establishes (acquires) connection objects.
This package works great when run from my local XP workstation. I can see the distributed transaction starting and committing in the SSIS output.
The problem is that when I roll this package out to the server, it fails to acquire the connection, throwing an error at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectinoMAnager100.AcquireConnection(Object pTransaction). I've verified that the
security settings of MSDTC on this server are consistent....they are definitely set to allow inbound and outbound.
Are there any issues with MSDTC on Windows Server 2008? Is it possible that I'm getting an issue because my workstation is 32 bit but the server is 64 bit?
View Complete Post