title: Error while executing an SSIS package with ODBC connection on SQL SERVER
body: <p>I've created a new SSIS package, it's correctly working using Visual Studio and an ODBC connection :</p>
  <p><a href="https://i.stack.imgur.com/eneHg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eneHg.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/4boiL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4boiL.png" alt="enter image description here" /></a></p>
  <p>But when I'm trying to execute it using a Job under SQL Server I have this error :</p>
  <pre><code>Copie t_agence:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is &quot;ODBC Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1&quot;.
  Copie t_agence:Error: The managed pipeline component &quot;Microsoft.SSISODBCSrc&quot; could not be loaded.  The exception was: Could not load type 'Microsoft.SSISODBCSrc' from assembly 'Microsoft.SqlServer.PipelineHost, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..
  </code></pre>
  <p>I don't remember that an ODBC driver is needed to be install under SQL Server to allow the ececution of a package using an ODBC connection...
  Could you give me hand on this please ?</p>