CODEWITHSUNDEEP
sql-serverssisodbc
Jaggana
Jaggana

Reputation: 580

Error while executing an SSIS package with ODBC connection on SQL SERVER

I've created a new SSIS package, it's correctly working using Visual Studio and an ODBC connection :

enter image description here enter image description here

But when I'm trying to execute it using a Job under SQL Server I have this error :

Copie t_agence:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "ODBC Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1".
Copie t_agence:Error: The managed pipeline component "Microsoft.SSISODBCSrc" 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'..

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 ?

Upvotes: 0

Views: 3113

Answers (1)

Jaggana
Jaggana

Reputation: 580

Well... The problem was "just" to select the correct SSMS version here : enter image description here

It took me 2 days... Thanks for your help guys.

Upvotes: 4

Related Questions