Recently, while working on Azure SQL Server to execute SSIS package, we found a strange issue.
We created the Azure SQL Server from Azure Portal. We designed the SSIS package using SSDT.
To deploy package to Azure SQL Server and execute there we need Azure-SSIS Integration Runtime(Azure-SSIS IR) to be setup. We created Azure Data Factory and did setup the Azure-SSIS IR.
After the above steps are completed, we tried to deploy the package to SSISDB catalog in Integration Services Catalog node. Unfortunately, we were unable to see the Integration Services Catalog node after connecting to the SSISDB database as shown below:
Click on Options to go to Connection Properties Tab and type SSISDB as shown:
Clicking Connect we were unable to see Integration Services Catalog.
We tried to select <default> database on Connection Properties Tab, still no luck.
After scratching head for almost an hour we found that name of database SSISDB is case sensitive 🙂
Trying with upper case SSISDB, we were able to see Integration Services Catalog.
Hope it helps !!