Shulou(Shulou.com)05/31 Report--

How to configure data source connection parameters through environment variables in SSIS? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Step 1: create a SSIS package

Create OLEDB Source and Flat File Destination connection managers in 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 conversation window

Note that the default value is the same as when you create a connection. After clicking OK, the parameters will be 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 successful execution

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

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

Step 7: right-click the project to configure the package of variables.

Step 8: configuration parameters, referencing environment variables

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

View information for "Connection Managers"

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

Step 9: set the Prod variable in the environment variable

Step 10: bind variables in the package configuration

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

Check the environment variable

This is the answer to the question about how to configure data source connection parameters through environment variables in SSIS. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.