SSIS 2016 connectivity to SQL server database 2019

Raja Mallela 21 Reputation points
2023-04-25T08:58:51.26+00:00

Hi, our current database server which is on sql 2014 reaching end of support and we would like to upgrade to sql server 2019. But there are few SSIS packages which are running on sql server version 2016 which connect to 2019, I wanted to know if SSIS running on sql server 2016 has any compatibility/connectivity issues with sql 2019, we cannot upgrade our SSIS packages at this point.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,491 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,561 Reputation points
    2023-04-25T09:20:07.0633333+00:00

    SSIS / Connections are a SQL Server client as any else, they aren't aware of the SQL Server version connecting to. And an "upgrade" of a SSIS package is an easy one, install the latest SSDT version, open the project(s), change "TargetServerVersion" to 2019, compile the project and deploy it.

    0 comments No comments

  2. ZoeHui-MSFT 34,581 Reputation points
    2023-04-26T02:05:26.33+00:00

    Hi @Raja Mallela,

    If the only changed thing is the data source which will not affect the SSIS package.

    From my opinion, there is need to upgrade SSIS package if it keeps running on sql server 2016.

    Regards,

    Zoe Hui


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