开发者

Microsoft SSIS 2005. Can't Use Transactions

开发者 https://www.devze.com 2022-12-08 02:49 出处:网络
I have set the package TransactionOption 开发者_如何转开发to Required and DataFlowTask\'s TransactionOption to Supported, but when I execute the package, I get an exception:

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消