title: SSIS Script task AcquireConnection returns Null
body: <p>In SSIS I have a connection defined with the following connection string:</p>
  
  <pre><code>Data Source=myserver;Initial Catalog=Spears;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;
  </code></pre>
  
  <p>i am attempting to use this connection from a script task:</p>
  
  <pre><code>ConnectionManager connectionManager = this.Dts.Connections["Spears"];
  object acquireConnection = connectionManager.AcquireConnection(this.Dts.Transaction);
  SqlConnection con = acquireConnection as SqlConnection;
  con.Open();
  </code></pre>
  
  <p>On execution </p>
  
  <ul>
  <li><strong>connectionManager</strong> comes back as a fully populated ConnectionManager
  object </li>
  <li><strong>acquireConnection</strong> is a System._ComObject </li>
  <li><strong>con</strong> is null </li>
  <li>obviously opening con fails</li>
  </ul>
  
  <p>Casting as OleDbConnection or OdbcConnection returns null as well.</p>
  
  <p>What am I doing wrong ?</p>