Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
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
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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