Share via

SSIS - Use Environment configuration in Visual Studio

Dominic Buschi 26 Reputation points
2021-02-03T10:05:53.45+00:00

I have created two environments which I use to parameterize my SSIS packages:
63491-ssisenvironments.png

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 25,731 Reputation points
    2021-02-03T13:44:49.173+00:00

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-04T02:25:30.937+00:00

    Hi @Dominic Buschi ,

    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.
    63802-usingenvironmentvariableinssisdbcatalog.png
    63803-executingssispackagewithenvironmentinssisdbcatalog.png
    63720-usingenvironmentvariableinjob.png

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

    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.