ssis MYSQL ODBC connection failing in sql server agent schedule

Question

One package we are using mysql ODBC connection. the package is running fine in visual studio but when we deployed to DB or file system in the same machine it is failing and giving below errors

Job History (CPS_execute_operations)

Step ID 1
Server SCRBBIDBMATMG02
Job Name CPS_execute_operations
Step Name stepa
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: Microsoft (R) SQL Server Execute Package Utility Version 12.0.6024.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:19:07 PM Error: 2021-05-12 14:19:07.59 Code: 0xC0016016 Source: Package1 Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2021-05-12 14:19:07.63 Code: 0xC00490F7 Source: Insert CPS executed to Raw Insert CPS executed to Raw (ODBC Source [7]) Description: 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'.. End Error Error: 2021-05-12 14:19:07.63 Code: 0xC0047076 Source: Insert CPS executed to Raw Insert CPS executed to Raw (SSIS.Pipeline) Description: Component ODBC Source, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D} failed to initialize due to error 0x80131600 "". End Error Error: 2021-05-12 14:19:07.63 Code: 0xC0048021 Source: Insert CPS executed to Raw Insert CPS executed to Raw (ODBC Source [7]) Description: 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". End Error Error: 2021-05-12 14:19:07.63 Code: 0xC004801F Source: Insert CPS executed to Raw Insert CPS executed to Raw (SSIS.Pipeline) Description: The component metadata for "ODBC Source" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2021-05-12 14:19:07.65 Code: 0xC004801F Source: Insert CPS executed to Raw SSIS.Pipeline Description: The component metadata for "ODBC Source, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2021-05-12 14:19:07.65 Code: 0xC0048021 Source: Insert CPS executed to Raw ODBC Source [7] Description: 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". End Error Error: 2021-05-12 14:19:07.65 Code: 0xC0047017 Source: Insert CPS executed to Raw SSIS.Pipeline Description: ODBC Source failed validation and returned error code 0xC0048021. End Error Error: 2021-05-12 14:19:07.65 Code: 0xC004700C Source: Insert CPS executed to Raw SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2021-05-12 14:19:07.65 Code: 0xC0024107 Source: Insert CPS executed to Raw Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:19:07 PM Finished: 2:19:07 PM Elapsed: 0.187 seconds. The package execution failed. The step failed.

The component metadata for "ODBC Source, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

Answer 1

Hi @Hazarath Reddy Boreddy ,

The component metadata for "ODBC Source, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

It seems that the component was developed with a higher version of SQL Server Integration Services.

Please check your SSIS version and make the TargetServerVersion to be the same as SSIS.

Check SSIS version (Connect to the SSIS instance via SSMS and then look at the build number in the brackets or right click and go to reports > standard reports > general and look at the build)

Right-click the project in the Solution Explorer and select Properties.

To display the TargetServerVersion option, go to Configuration properties and then General.

change the TargetServerVersion parameter to the same as SSIS.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October