title: SSIS Sequence container Transaction Option
body: <p>I have an SSIS package which is pretty simple, just a data import and an execute SQL task thereafter.  I want to roll everything back if any part of the package should fail so I put these tasks within a Sequence Container and set the Sequence Container TransactionOption property to 'Required' and set FailPackageonFailure property to 'True'.  This worked fine when I was targeting the local db.  However when I try to change the OLE DB Connection to a remote server the aforementioned property settings cause the package to hang and finally fail with a message of 'Could Not Acquire Connection'.  I have seen similar descriptions of this problem on the web but the advise is always to check the Connection.  However I know the connection is fine because when I change TransactionOption property back to its default of 'Supported' the package runs fine. </p>
  
  <p>Does anyone know why this could occur?  I'm assuming it has something to do with different settings on the server I'm trying to connect to.  Also does anyone know a different way of ensuring a complete rollback if any part of the package should fail.  </p>
  
  <p>Thanks for reading </p>