Microsoft SSIS 2005. Can't Use Transactions
I have set the package TransactionOption
开发者_如何转开发to Required
and DataFlowTask
's TransactionOption
to Supported
, but when I execute the package, I get an exception:
[ADO NET Destination [82]] Error: The transaction has already been implicitly or explicitly committed or aborted
Why does this happen, and how can I fix it?
Here is my solution [http://faiz.kera.la/2009/08/26/ssis-transaction-enabled-tasks-fail-due-to-msdtc]. I recommend a little googling before posting here, as per the StackOverflow guide lines.
精彩评论