Rollback whole package settings in case error occurs in SSIS packages

Posted on 2011-10-04
Last Modified: 2012-05-12

I am importing data from flat files to database. For avoiding inconsistency; if error occurs during execution of package then whole package should be rollback.

So, what I did that I marked TransactionOption = "Required". But when I tried to this then it says MSDTC service should run. Okay, I ran that service as well.
As destination server is on remote, then it does say Allow Inbound/Outbound setting needs to be done. But still, it is giving an error DTC error.

My question is that

1. Can anyone give step wise screen shots for setting MSDTC?

Best Regards,
Mohit Sharma
Question by:MohitPandit
    LVL 5

    Author Comment

    Below is the error:

    The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 "The partner transaction manager has disabled its support for remote/network transactions

    Apart from this, I don't have SSIS service installed on my machine. But I can run SSIS directly from BIDS (Business Intelligence Development Studio). Does it affect?
    LVL 26

    Accepted Solution

    you should also check the RPC service state alond with the MSDTC... it should be running...
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Hey make sure if destination server is remote then MSDTC needs to be enabled in remote server as well and check inbound and outbound request in MSDTC.
    LVL 5

    Author Comment

    Can it be possible due to SSIS Service? Like I aforesaid, I don't have SSIS service installed on my machine. I am using directly BIDS for making packages as I can't execute package directly as I don't have SSIS service.

    Any feedback?
    LVL 5

    Author Closing Comment


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now