SSIS Package Configurations Instances

Source: Internet
Author: User
Tags configuration settings ssis

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.