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.
SSIS 2016 connectivity to SQL server database 2019
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.
2 answers
Sort by: Most helpful
-
-
ZoeHui-MSFT 35,556 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.