Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    6

    Unanswered: DTS Package failure

    I have a DTS package which keeps failing giving me the error message “A connection with the transaction manager was lost". The DTS package is using two different servers as connection and the DTS package has Use Transaction, Rollback transaction on failure and Join transaction if present ticked. I have checked the MSDTC service is running on both servers, the following options on both servers have been checked; Network DTC Access, Allow Inbound and Outbound. Does anybody know what is causing this error message?

    Any suggestions much appreciated.

    Regards
    Amber
    Last edited by Amber_Robertsona; 01-29-07 at 05:42.

  2. #2
    Join Date
    Jan 2007
    Posts
    6
    This is no longer a problem as we removed Use Transactions on the DTS package and added additional steps on failure to allow rollback.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •