question

GregBooth-2902 avatar image
0 Votes"
GregBooth-2902 asked OlafHelper-2800 answered

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

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-generalsql-server-reporting-servicessql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

qasimali avatar image
0 Votes"
qasimali answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.