Parameters能夠在Project Deployment Model下使用，不能在Package Deployment Model使用。在Package Deployment Model下，使用Package Configurations來傳遞屬性值；在Project Deployment Model下，使用Parameters來傳遞值。

成都創(chuàng)新互聯(lián)是一家專注于做網站、成都網站制作與策劃設計,富蘊網站建設哪家好?成都創(chuàng)新互聯(lián)做網站,專注于網站建設十載,網設計領域的專業(yè)建站公司;建站業(yè)務涵蓋:富蘊等地區(qū)。富蘊做網站價格咨詢:18980820575

 

1，Parameters and Package Deployment Model

In general, if you are deploying a package using the package deployment model, you should use configurations instead of parameters.

When you deploy a package that contains parameters using the package deployment model and then execute the package, the parameters are not called during execution. If the package contains package parameters and expressions within the package use the parameters, the resulting values are applied at runtime. If the package contains project parameters, the package execution may fail.

 

2，Parameters分為兩個Level，Project Level 和 Package Level，這兩個level的parameters value都存儲在project files。

Project Parameters values  and Packages parameters values are stored in configurations in the project file。

Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package.

 

一，Package Parameter

1，在Project Deployment Model下，打開parameters選項卡，New一個Package Parameter，Parameter 名字是ParameterA。

Sensitive：敏感信息，需要加密

Required：必須提供，否則會出錯

 

Property	Description
Name	The name of the parameter.
Data type	The data type of the parameter.
Default value	The default value for the parameter assigned at design time. This is also known as the design default.
Sensitive	Sensitive parameter values are encrypted in the catalog and appear as a NULL value when viewed with Transact-SQL or SQL Server Management Studio.
Required	Requires that a value, other than the design default, is specified before the package can execute.
Description	For maintainability, the description of the parameter. In SQL Server Data Tools (SSDT), set the parameter description in the Visual Studio Properties window when the parameter is selected in the applicable parameters window.

 

2，Add parameters to Configurations

 

3,Set Parameter Values After the Project Is Deployed

The Deployment Wizard allows you to set server default parameter values when you deploy your project to the catalog. After your project is in the catalog, you can use SQL Server Management Studio (SSMS) Object Explorer or Transact-SQL to set server default values.

To set server defaults with SSMS Object Explorer:

1. Select and right-click the project under the Integration Services node.

2. Click Properties to open the Project Properties dialog window.

3. Open the parameters page by clicking Parameters under Select a page.

4. Select the desired parameter in the Parameters list. Note: The Container column helps distinguish project parameters from package parameters.

5. In the Value column, specify the desired server default parameter value.

To set server defaults with Transact-SQL, use the catalog.set_object_parameter_value (SSISDB Database) stored procedure. To view current server defaults, query the catalog.object_parameters (SSISDB Database) view. To clear a server default value, use the catalog.clear_object_parameter_value (SSISDB Database) stored procedure.

 

MSDN上提供兩種方法，一種是使用SSMS來修改，一種是使用TSQL語句來修改

3.1 使用SSMS來修改

選中integration Services Catalogs，右鍵點擊TestISProjects，打開Configure

 

 

點擊... 來設置參數(shù)的值

 

 

二，Project Parameter

1，在Project視圖下，打開Project.params，創(chuàng)建一個project level 的Parameter， 命名為ProjectParameter_A。

2，將Project Parameter 添加到configurations中，

 

 

3，發(fā)布到Sql server之后，修改Project parameter的default value。

 

 

 

三，Use of package and project parameters

Parameters are useful for providing runtime values to properties during a package execution. Hence, in a way they replace the concept of configurations that we had for SSIS packages.

Package parameters are useful for providing values to specific package executions. As they are package scope, they would only be available to the package in which they were created.

Project parameters are available to all the packages in a project. They are useful for configuring values which can be shared between packages. For instance if you wanted to have a single parameter containing a server name to be used by multiple packages, then Project Parameters will be useful for you.

You can use a parameter anywhere in an expression by referring it using the following syntax:

@[$<<Project/Package>>::<<ParameterName>>]

The evaluation order is similar to using a variable in an expression and then executing a package. Hence, the value gets evaluated and assigned to the property at Validation phase.

名稱欄目：SSISParameter用法
URL網址：http://jinyejixie.com/article40/ppiseo.html

成都網站建設公司_創(chuàng)新互聯(lián)，為您提供建站公司、網站營銷、微信公眾號、移動網站建設、定制網站、App設計

廣告

聲明：本網站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)