I have a Data Flow Task. I have set its Transaction Option to Required.
This Data Flow Task is basically used to load data into a fact table.
Before the data is inserted into the fact table, I simply do a lookup to see if the row is already in the fact table. If it is already there, rows will be redirected to an OLEDB command which does an update to the corresponding row.
However the OLEDB command failed with the error - "This operation conflicts with another pending operation on this transaction. The operation failed."
Is there a work around? Thanks.