Today I received the below error message when executing a SSIS catalog SSIS package from an Agent job:
We currently have an Environment Variable that has variables that contain the full connection string of the database:
We then set the ConnectionString property of the relevant database connection on the Connection Managers tab when configuring the SSIS Catalog:
The above error was caused by setting the InitialCatalog to use the Environment Variable variable instead of setting the ConnectionString to use the variable. Once the properties were swapped the issue disappeared!