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

Greg Booth 1,296 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.
12,852 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,818 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 41,006 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 No comments

1 additional answer

Sort by: Most helpful
  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 No comments