We've a package SSIS 2017
that need to execute more packages and every package need to inherit transaction from starting package.
Following microsoft guide:
Starting Package has TransactionOption = Required
and every Execute Package has TransactionOption = Supported
and every package is set to Supported.
When executed we have following error
"DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SIVA_OLEDB" failed with error code 0xC0202009." in the first package called by the starter.
Where are we wrong? p.s. We tried other combinations without results.
User contributions licensed under CC BY-SA 3.0