title: SSIS OlEDB Connection manager Error
body: <p>When am using sequence container to roll back my transactions in execute sql task i am getting the error
  Connection manager  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.".
  have set the transaction property to "Required" for Sequence container and inside all dataflow , execute sql tasks.
  i am using two sql servers one is source other is target in the network. please help</p>