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