Attempt at SSIS Execution Throws Invalid object name 'SSISDB.catalog.customized_logging_levels'

0
votes

I can run the SSIS package in SSMS 2014 if I set the build to SQL Server 2012, but attempting to run in SSMS 2017 v17.4 gives this error:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

Invalid object name 'SSISDB.catalog.customized_logging_levels'. (Microsoft SQL Server, Error: 208)"

There is little info out there as to a fix.

2
sqlsql-serverssisssms

2 Answers

0
votes
  1. Backup SSISDB database from SSMS 2014.
  2. Create Integration Service catalog on SSMS 2017 and restore backup.
  3. Change the SSISDB database owner sa.
  4. Right click on SSISDB under Integration Service Catalogs.
  5. Select Database Upgrade-> Select Next -> Select I have taken backup of the SSISDB database. continue with the SSISDB upgrade and Select Upgrade.
0
votes

Delete the existing SSISDB Database, Then Integration Services Catalog -> (Right click) Create New Catalog