SSIS uses environment variables to configure data source connection Parameters

SSIS uses environment variables to configure data source connection Parameters

Step 1: Create an SSIS package

Create the OLEDB Source and Flat File Destination Connection Manager in the Data Flow Task.

Step 2: Configure parameters on the Connection Manager.

Right-click the Connection Manager and select "Parameterize"

Step 3: Select ConnectionString in the Parameterize dialog window

Note that the default value is the same as when you create a connection. After you click OK, the Parameter is displayed in the "Parameter" tab.

Confirm the connection information in the "Parameter" tab.

Step 4: Execute Data Flow Task or the entire package in SSDT to ensure the execution is successful.

Step 5: deploy the project to SQL Server 2012 in SSISDB (now you should connect SQL Server in SSMS and enter Integration Services Catalog)

Step 6: Right-click Environments and select "Create Environment ...."

Step 7: Right-click the project and configure the variable package.

Step 8: Configure parameters and reference environment variables

On the "Parameters" tab, view the parameter values:

View "Connection Managers" Information

In "Configur ...." Click References in the window to reference the environment variable

Step 9: Set the Prod variable in the Environment Variable

Step 10: bind a variable to the package Configuration

Step 11: Execute our package and select the bound environment variable.

Check Environment Variables

Reference:

Http://msdn.microsoft.com/en-us/library/hh213230.aspx

Http://blogs.msdn.com/ B /mattm/archive/2011/07/22/parameterized-connection-managers.aspx

Http://blogs.msdn.com/ B /mattm/archive/2011/07/25/all-about-server-environments.aspx

Connection: http://blogs.msdn.com/ B /meer_alam/archive/2014/08/11/ssis-data-source-connection-information-parameterization-with-environment-variable.aspx