SSIS Package Configurations Instances

Study the SSIS package configurations today and record the learning process

1. Switch the Deployment model to the package Deployment model
The default Deployment model for SSIS is Project Deployment model, right-click Project and select Convert to package Deployment model.

2, add a variable and an Execute SQL task in the package, execute the SQL statement in Execute SQL task as follows, insert the value of the variable into the table

Insert  into dbo.dt_test Values (1,?,'a')

3,enable Package Configurations

Under SSIS menu, click Package Configurations, or right-click in the blank of the package, pop-up the shortcut menu, select Package configurations, open the package configurations Wizard

Enable Package Configurations

4,add Package Configurations

Select SQL Server configuration type,specify configuration settings directly.

5. Select the properties you want to configure to the package configurations

The value of the variable Varcode is configured in the package configurations, and the value of the variable varcode is stored in [dbo]. [SSIS configurations], when the package executes, reads the value and takes the read value as the value of the variable Varcode for use by the package.

6. View configuration information

Select the configuration type for SQL Server, which is stored in a table in SQL Server, and the specified table name is [dbo]. [SSIS configurations]

Select *  from [dbo]. [SSIS configurations]

7. Execute the package to see the results of the execution

Select *  from Dbo.dt_test

8, modify [dbo]. [SSIS configurations] ConfiguredValue, run the package again to see the results of the package run

Update [dbo]. [SSIS configurations] Set ConfiguredValue=2

SSIS Package Configurations Instances