BIWorking with SSIS Configurations and Deployment Model
Package configurations is very important to achieve flexibility SSIS package, easy configurations allow used to changes and reuse the solutions in different environment with them customize settings and rules.
SSIS package supports different types of configurations, these package configurations is also depended on deployment model.
In this blog we will discuss about the Project Parameter configuration using the Project Deployment model.
- Let’s make the SSIS package Solution to Project Deployment model.
- Right Click on the SSISProject Solution Name, Click Project Deployment Model.
- Follow the Wizard:
- Click Next: This will provide you list of packages that you need to convert, then click next.
- Next will be setting up the protection Layer for the Package:
- Then Click on Next and then it will convert your Solution to Project Deployment model.
Project Deployment Model allows you to configure the package at project level, it groups the Package configurations together that allows user to easily configure Parameter.