Share via

Will SSIS 2012 and SSRS 2012 be able to connect to a sql 2016 database ?

Greg Booth 1,336 Reputation points
2021-08-05T22:27:25.5+00:00

We have a database that is running on a sql 2016 instance, but its still in sql 2008 compatibility level.
We would like to change the compatibility level to SQL 2016.
The database is heavily accessed by packages running from Sql server integration services (SSIS) instance using sql 2012, also an instance of reporting service (SSRS) 2012.

IS there any danger changing the database to 2016 compatibility when we are still using SSIS and SSRS 2012 ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,150 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,950 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,610 questions
0 comments
Accepted answer
  1. Olaf Helper 45,366 Reputation points
    2021-08-06T05:38:37.877+00:00

    IS there any danger changing the database to 2016 compatibility when we are still using SSIS and SSRS 2012 ?

    No, SSIS and SSRS are SQL Server clienst as any other client, like SSMS, SqlCmd or Excel and so on.
    The clients are not really aware of the Server version or database compatibilty level; that should work.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Qasim Ali 86 Reputation points
    2021-08-05T23:51:31.743+00:00

    Since the SQL Server 2016 release, SQL Server Data Tools supports backwards compatibility up to SQL Server 2012

    https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.