Share via

ssis package upgrade fail

Asharaf Ali 61 Reputation points
2024-05-22T06:09:17.5433333+00:00

I am trying to upgrade my SSIS packages from sql 2016 to 2019. The steps I did is opened the project in Visual Studio 2022, and then set the targetversion to 2019. And then Upgrade all the packages. It completed without any errors. But when I open one of my packages, it throws an error as mentioned below. The error is from OLE DB command component.

Any idea on this error or any suggestion to resolve the issue?

Severity Code Description Project File Line Suppression State

Error Error loading myPackage.dtsx: The component metadata for "Script Component" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. D:\SSISPk\myPackage.dtsx 1

Thanks,

Ashr

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,958 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,476 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. hossein jalilian 4,385 Reputation points
    2024-05-22T06:23:53.6966667+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    Here are some potential solutions to resolve this issue:

    • Ensure that all components in your SSIS package are compatible with SQL Server 2019. Sometimes, certain components may not upgrade seamlessly due to version differences
    • If your ‍‍Script Component contains custom code, review it carefully. Make sure it adheres to the latest standards and is compatible with the new version
    • Create a new Script Component in your upgraded package and manually copy the logic from the old one.
    • If your Script Component references external assemblies or libraries, ensure that they are compatible with SQL Server 2019.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

    1 person found this answer helpful.
  2. ZoeHui-MSFT 33,946 Reputation points
    2024-05-22T07:15:03.8+00:00

    Hi @Asharaf Ali,

    Please try with below method, make a copy of your package first:

    --change TargetServerVersion to SQL Server 2019

    --open the .dtsx file for each package in Notepad++ or other text editor

    --remove the following in the dtsx file <PropertyGroup><TargetFrameworkVersion>v4.0</TargetFrameworkVersion></PropertyGroup>

    --save the .dtsx file

    --go back into Visual Studio and rebuild the project file

    Regards，

    Zoe Hui

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

  3. Asharaf Ali 61 Reputation points
    2024-05-22T15:35:54.7266667+00:00

    xxxxxxxxxxxx

    0 comments