Failure validating ssrs instance mssqlserver
So before I jump into an example, let me first explain some of the key terms: Project Deployment Model As I said before, this is the new deployment model for SSIS projects.
This means that when you are executing your project/package you need to specify a single environment to use for that execution instance.
To learn more about Project Deployment Model click here.
Integration Service Catalog You can create one Integration Services catalog per SQL Server instance.
A project parameter can be used in any package of the project whereas the package level parameter is specific to the package where it has been defined.
The best part of these parameters is that you can mark any of them as sensitive and it will be stored in an encrypted form in the catalog.