SSIS – Create Environment from Packages variables

SSIS – Create Environment from Packages variables

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! 🙂

    SSIS – Log Execution time

    SSIS – Log Execution time

    This query helps you to have a better view of your SSIS Packages executions. When you run a “master job / package”, you don’t clearly see the execution time for your child packages in SSISDB Reports. With this query, now it’s possible 🙂

    Pin It on Pinterest