ssis package upgrade fail

Question

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

Answer 1

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

Answer 2

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.

Answer 3

xxxxxxxxxxxx