开发者

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.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜