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.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  SSIS transaction

Author  Topic  pecunn Starting Member 20 Posts Posted - 2011-06-16 : 22:09:51 Hi experts, i have package with single sequence container(parent) and multiple containers inside the parent (child). i followed the steps in here for single and multiple transaction but i got no luck http://msdn.microsoft.com/en-us/library/ms141144.aspx basically in package is set transaction as support. parent container is set to required. child container is set to support. DTS has been enabled and i am logged in as db owner. im receiving this error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC001A004 can anyone help me? Regards,