Post reply

Transaction to rollback

  • December 9, 2008 at 1:35 pm

    #126398

    Hi all,,

    I am lookup for clubbing two dataflow task in a seqence contrainer and make sure that only when both are success it shud be ok otherwise roollback precious load too..

    I m using Transaction in contaner = required...but it is giving error MSTDC not runnig.?

    any clue?

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • December 10, 2008 at 3:05 am

    #910181

    Hi,

    In order to use transactions within SSIS you need to have MSDTC running and running on the same machine that is executing the package.

  • December 10, 2008 at 7:24 am

    #910338

    I have started the service MSDTC..

    but now it fails saying that unable to ACQUIRE CONNECTION OLEDB.

    Actually it works fine if I remove required property from SEQ container tX but fails saying Unable to acquire connection if I make it REQIRED..

    any help?

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

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

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