SSIS - Use Environment configuration in Visual Studio

Question

I have created two environments which I use to parameterize my SSIS packages:

This works fine when executing the packages in SSMS. But I cannot find a way to get it to work in Visual Studio, so that the package parameters in Visual Studio use the values from my Development environment. Is there a way to hook up my parameters to the environment?
Thanks for your help.
Dominic

Answer 1

Overall, SSIS has 2 environments:

• Development environment, on a dev. workstation, with VS and SSDT (or SQL Server Integration Services Projects for VS2019)
• Run-time environment, on a server with SQL Server instance and SSIS with SSISDB Catalog.

SSISDB Catalog Environments are just named sets of configuration parameters/settings. By using them and naming as such you can simulate Test, UAT, Production, and the like environments on the same (one and only) physical SSIS run-time server. That was the reason to name that SSIS feature as Environments.

SSISDB Catalog Environments are just for a SSIS run-time environment on a server. They are out of reach for VS in a dev. environment.

Answer 2

Hi @Anonymous ,

1.Environment variables can be used to set parameters' value of SSIS project or package at the time a package is executed in SSISDB Catalog or SQL Server Agent Job.

2.If we want to set parameters' value of SSIS project or package in Visual Studio, we can change them directly.

3.Please refer to Parameterizing Connections and Values at Runtime Using SSIS Environment Variables.

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.