› BI › Working with SSIS Configurations and Deployment Model

Working with SSIS Configurations and Deployment Model

 Jayant Patel   Leave a comment

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.

  1. Let’s make the SSIS package Solution to Project Deployment model.
  2. Right Click on the SSISProject Solution Name, Click Project Deployment Model.
  3. Follow the Wizard:
  4. Click Next: This will provide you list of packages that you need to convert, then click next.
  5. Next will be setting up the protection Layer for the Package:
  6. 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.

Liked it? Share it.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.