SSIS Transaction among packages

0

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.

ssis
sql-server-2017
asked on Stack Overflow Nov 29, 2019 by SimoneG • edited Nov 29, 2019 by Ajeet Verma

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0