This week I had another SSIS bug to kill. :)
I have 3 SSIS packages: 2 child and 1 master
The Control Flow for the first one is integrated in a Sequence Container to having the rollback ability.
When editing the Sequence Container properties there is TransactionOption set to Required.
For the second package we have another sequence container with the same options.
But the Master one has 2 Execute Package Task only.
In the Properties window of Master package there is the same option named TransactionOption set to Supported.
So, all these packages are working fine on the server.
The problem appears when moving them to another server: the client server
After modifying all the connection strings for all the packages an error appears:
[OLE DB State Source [1565]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DDBillingPortal_TempLive.dd" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I was searching through a lot of articles but nobody was offering a solution to this error. Finally, the problem is related to that TransactionOption set to Required instead of Supported in those 2 packages.
