All,
I have an SSIS package which calls several other SSIS packages. The "mother" package has TrasactionOption set to "Supported". There is a sequence container and an imbedded Execute Package Task for each of my embedded packages. Each of the sequence containers has TransactionOption = Required. DTC is running.
When I run my mother package I get the following error within the first package executed "Bulk Insert with another outstanding result set should be run with XACT_ABORT on." I've looked high and low for others with this problem, but haven't found any resolution. Can anyone tell me how to resolve this error? I have tried using BEGIN TRANSACTION instead of using Required and I turn on XACT_ABORT, but it doesn't seem to help either. Any help on this would be greatly appreciated.
Thanks
Update on this - I was able to get around this problem by switching to using native SQL Server transactions. However, it still puzzles me that I can't use DTC instead. Please, any help on this problem would be greatly appreciated. Just to add a little more information - there is a SQL Server 2005 instance (destination) and a SQL Server 2000 instance (source) involved. Microsoft? Any answer on this?