I am trying to implement transaction in SSIS for the first time. We are going to migrate few records from source to destination tables using DFT. We are planning to have multiple threads inside the DFT. So if one of the thread fails, the data migration happened thru other threads too should roll back.
I am putting the DFT in a sequence container and setting the transactionoption to required and setting the trasactionoption property of DFTs inside the seq container to supported.
I am getting an error while executing the package. I have started the DTC using Administrative tools. I am still getting the error "The partner transaction manager has disabled its support for remote/network transactions". I saw in few threads that we have to enable remote access thru Component Services.
I am accessing the DB through VPN.
Please help me in resolving the issue.
I am not completely sure about the issue you are receiving ..
but I hope this link helps..
Wondering what I would do next , when I am done with this one