开发者

SSIS package with trigger on the table

开发者 https://www.devze.com 2023-01-04 10:40 出处:网络
I have an SSIS package on Sql server 2008 which inserts data into a table in a transaction. There is a trigger on the table. That is causing the following exception while inserting -

I have an SSIS package on Sql server 2008 which inserts data into a table in a transaction. There is a trigger on the table. That is causing the following exception while inserting -

Bulk Insert with another outstanding result set should be run开发者_Python百科 with XACT_ABORT on

I am using OLEDB. How can I fix the error.


Can you disable the trigger?

Here is a thread on this issue: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5be1bab7-74c1-4d1c-a6f7-7d0c925dce12

0

精彩评论

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

关注公众号