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