Integration Services in VS 2019 Version Mismatch with the one in SQL server 2019

Ashley Gobio 1 Reputation point
2020-12-28T17:54:58.36+00:00

I am SSIS in C# developer. We have an application invoking SSIS packages in C# prgram. We recently upgraded the SSIS packages using VS 2019, so the Integration Services installed with VS 2019 is version 1.3. We are planning to move the program into production Environment in which VS 2019 is not allowed to install. So we installed integration services using 2019 SQL server installer. It doesn't work since the Integration Services included SQL server 2019 is version 1.5. The program can't find the right reference and throw error msg saying can't find Integration Services.

Is there a way to build SSIS packages that can reference to multiple versions of Integration Services? Or is there a way to install the Integration Services 1.3 without install vs 2019?

This is urget! Please help!

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,593 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashley Gobio 1 Reputation point
    2020-12-30T16:28:58.487+00:00

    The reason I made that comment is that the development work is done on the targetServerVersion =SQL Server 2014. The update is for an urgent fix so that we want to deploy it as soon as possible. Moving to SQL 2019 requires upgrade the SSIS packages and installation of SQL Server 2019. Too much work for an urgent fix.