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.