I have recently deployed some SSIS packages. I made a job to run them one after another. However, I am now allowed to use MSDTC. So I chained the jobs together like I have done before, but now I am faced with an error message about DCOM. All Internet research points to insufficient permissions on the MSDTC component, but I am worried this is going the wrong way.

Any idea how I can "reset" the need for MSDTC for this package?

  • If you're using transactions inside the SSIS packages, they are employed using MS DTC (distributed transaction coordinator). See more here. – Marian Apr 22 '13 at 21:16

The job has several steps. In the step that ran the package, I had to select "SQL Server" as the package source instead of "SQL Server Package Store". This stopped the use of MSDTC.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.