I have a package with a sequence container that has TransactionOption = Required. Within the sequence container are two SQL tasks that each call a (different) stored procedure. Neither stored procedure starts or commits a transaction. The
SQL tasks run at the same time by design - they are lengthy and independent processes and I want them running at the same time. However, when I do this the package fails with the message that DTC has cancelled the transaction.
DTC is configured properly on my machine and both the SQL task procedures will run successfully if the other task is disabled. Also, they will both run successfully if I use a connector to force them to run sequentially instead of simultaneously.
I have used isolation levels of ReadCommited and Serializable and the outcome always is failure. Do you know what is causing the parallel executions to fail or what I could try to overcome this problem?
View Complete Post