SSIS – Create Environment from Packages variables

by SSIS, Tips & Tricks0 comments

I created this script to automate some “not funny” tasks with our SSIS Catalog. If you have several SSIS projects configured in project mode (with a project.params file), when deploy them on your servers you unfortunately have to manually create the different environments.

After deploying SSIS packages, you can run the following query and use the generated SQL code.

the generated SQL script:

  • Create the different environment (Based on the name of the projects)
  • Create variables with default values (value available in packages)
  • Assigning Environments to Projects
  • Assign the environment variables to the project variables.

The following code is not clean, but it does the work! 🙂


    Submit a Comment

    Your email address will not be published.

    Stay Up To Date!
    Join the newsletter


    Pin It on Pinterest

    Share This