SSIS TransactionProperty

  • Hi All,

    Greetings!!!

    If I set the "TransactionOption=Required" property of Dataflow task,

    DTC Service should be Enable/Start.

    My server location and Development Package location is different.

    which system(i.e. Server OR Development ) DTC should be Enable/Start.

    Thanks In Advance

    Regards

    Indher sarvade

  • It should be started on the server.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I have it running on every SQL server.

    CEWII

  • Thank you very much

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply