SSIS package with trigger on the table

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 with XACT_ABORT on

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

Answers


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


Need Your Help

How to allow apache read files created by another user on cpanel

apache cpanel centos6 whm

I have project on CPANEL, where another application creates files by another user.And when I want to access to these files, apache return 404 error.Apache log:

Mvvm-Light Silverlight, using EventToCommand with a Combobox

silverlight selecteditem mvvm-light

I've hooked up a ComboBox's SelectedItemChangeEvent to a ICommand in my view model. Everything seems to be working fine however I do not know how to get the SelectedItem of the ComboxBox. I think I...