April 4, 2009 at 1:01 pm
Hello All,
I have a following scenario in ssis dataflow task.
Data gets uploaded from oledb data source into another table in same database using oledb destination. The destination table has instead of insert trigger on it. This trigger is used to handle duplicate records, & moves the records into different table.
This task is running in transaction.
The flow works without transaction perfectly. When the transaction is put, it is able to transfer 1477 records properly, but beyond that it gives oledb connection failure error.
What can be reason ? Is the trigger putting lock, which is not allowing transaction to work ?
Regards,
Arati
April 6, 2009 at 7:23 am
can u pls give the entire error msg.
April 8, 2009 at 9:43 pm
Hi,
It is oledb connection failure. Connection failure at oledb source.
Regards,
Arati
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply