SSIS Package is not loading in VS2019 - The Argument type "System.__ComObject' cannot be converted into parameter type "Microsoft.SqlServer.Dts.Pipleline.Wrapper.IDTSPipeline100'

Question

Hi All,

We are trying to migrate SSIS 2014 packages to SSIS 2019. We are using Package Deployment Model only. Under one solution we have multiple Projects and under one projects we have 4-5 packages.

I selected one project, and in properties I changed to Target server version from 2014 to 2019. It converted all 5 packages under that project successfully.

4 out of 5 packages are opening without any issue. But I am not able to open 1 package, firstly it takes lot of time to open the package and then it fails to open it with the following error message -

This package has script tasks, which is using some dlls also. Can anybody suggest what is the issue.

Our aim is to just lift and shift the packages from 2014 to 2019 without breaking the functionality. We are not aiming to use any of the new features.

Answer 1

Hi @Anupriya Athalye,

This is a well-known issue. Script tasks require recompilation after migrating to 2019 as they hold onto old .net references.

In addition, as said here, Script Task and Script Component scripts that explicitly reference ADODB.dll may not upgrade or run on machines without SQL Server Management Studio or SQL Server Data Tools (SSDT) installed. In order to upgrade these Script Task or Script Component scripts, it is recommended that you remove the dependency on ADODB.dll. Ado.Net is the recommended alternative for managed code such as VB and C# scripts.

You may have a double check.

Regards，

Zoe Hui

---

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