title: Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
body: <p>I'm working on a Data Mart loading package in SSIS 2012.  When attempting to execute the package in Visual Studio I get this error: </p>
  
  <blockquote>
    <p>"The AcquireConnection method call to the connection manager Data
    Warehouse.ssusr failed with error code 0xC0014009".</p>
  </blockquote>
  
  <p>When I test the connectivity of the Connection Manager Data Warehouse.ssusr I see that it passes.  </p>
  
  <p>When I execute the package outside of Visual Studio using the Execute Package Utility, the package runs.  </p>
  
  <p>I don't understand what's going on.  </p>
  
  <p>The package also refuses to run using the SQL Server Job Schedule, if that has anything to do with anything.  </p>