smart_analyst (9/3/2014)
I tried again with new project and new package. All 4 Execute SQL package works outside Sequence container but, inside the 1st Exec SQL package fails.....Does anyone else know? It looks like there should be a very simple solution for this.
The most simple solution is to turn off the transaction property.
If the transaction is needed, you need to dive deeper into MSDTC configuration.
Another option is to create the transaction yourself.
SSIS Transactions without MSDTC[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP