title: TransactionOption in SSIS
body: <p>I have created a SSIS package. I need to apply Transaction to this package for rollbacking in case the package fails. What I found is a property "TransactionOption" which should be given "Required". Am I right ? And I have set TransactionOption for the package as "Required" But the package fails when I executed. What all steps should I do for setting TransactionOption "required" ?</p>
  
  <p>In detail, My package contains 4 control tasks. One of them is a Data Flow Task, containing Lookup Tasks. </p>
  
  <p>I got the following error 
  "[Execute SQL Task] Error: Failed to acquire connection "SQLConnectionMgr1". Connection may not be configured correctly or you may not have the right permissions on this connection."</p>
  
  <p>When I set the TransactionOption to "Supported", the packages runs successfully.</p>