IDTSPropertiesProvider.SetExpression(String, String) Method

Definition

将指定的表达式分配给属性。Assigns the specified expression to the property. 指定 null 将从属性中删除现有表达式。Specify null to remove an existing expression from the property.

public:
 void SetExpression(System::String ^ propertyName, System::String ^ expression);
public void SetExpression (string propertyName, string expression);
abstract member SetExpression : string * string -> unit
Public Sub SetExpression (propertyName As String, expression As String)

Parameters

propertyName
String

向其分配表达式的属性的名称。The name of the property to which to assign the expression.

expression
String

表达式。The expression.

Examples

ConnectionManager类继承自 IDTSPropertiesProvider 接口。The ConnectionManager class inherits from the IDTSPropertiesProvider interface. 下面的代码示例演示 ConnectionManager 使用 SetExpression 它所继承的和方法的类 GetExpressionThe following code example shows the ConnectionManager class using the SetExpression and GetExpression methods that it inherited.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  
  
namespace ConnMgr_Properties_Collection  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            // The package is one of the SSIS Samples.  
            string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";  
  
            // Create an application and load the sample.  
            Application app = new Application();  
            Package pkg = app.LoadPackage(mySample, null);  
            Connections myConns = pkg.Connections;  
  
            // Get the Properties collection from the connection manager.  
            ConnectionManager myConnMgr = myConns[0];  
            DtsProperties connProperties = myConnMgr.Properties;  
  
            // View information about the RetainSameConnection property   
            // before setting it using the SetExpression method.  
            Boolean hasProperty = connProperties.Contains("RetainSameConnection");  
            Console.WriteLine("has RetainSameConnection? {0}", hasProperty);  
            Object myValue = myConnMgr.Properties["RetainSameConnection"].GetValue(myConnMgr);  
            String mySValue = myValue.ToString();  
            Console.WriteLine("value before is {0}", mySValue);String myTrueString = "true";  
  
            // Use SetExpression to set the value to true.  
myConnMgr.Properties["RetainSameConnection"].SetExpression(myConnMgr, myTrueString);  
  
            // Validate the package to set the expression on the property.  
            DTSExecResult valResult = pkg.Validate(myConns, null, null, null);  
  
            // Now that the value has been set, retrieve the value  
            // and the expression.  
            myValue = myConnMgr.Properties["RetainSameConnection"].GetValue(myConnMgr);  
            mySValue = myValue.ToString();  
            String myExpression = myConnMgr.Properties["RetainSameConnection"].GetExpression(myConnMgr);  
            String mySExpression = myExpression.ToString();  
            Console.WriteLine("value and expression is {0}, {1}", mySValue, mySExpression);   
        }  
    }  
}  
Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
  
Namespace ConnMgr_Properties_Collection  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
        ' The package is one of the SSIS Samples.  
        Dim mySample As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"  
  
        ' Create an application and load the sample.  
        Dim app As New Application()  
        Dim pkg As Package = app.LoadPackage(mySample, Nothing)  
        Dim myConns As Connections = pkg.Connections  
  
        ' Get the Properties collection from the connection manager.  
        Dim myConnMgr As ConnectionManager = myConns(0)  
        Dim connProperties As DtsProperties = myConnMgr.Properties  
  
        ' View information about the RetainSameConnection property   
        ' before setting it using the SetExpression method.  
        Dim hasProperty As [Boolean] = connProperties.Contains("RetainSameConnection")  
        Console.WriteLine("has RetainSameConnection? {0}", hasProperty)  
        Dim myValue As [Object] = myConnMgr.Properties("RetainSameConnection").GetValue(myConnMgr)  
        Dim mySValue As String = myValue.ToString()  
        Console.WriteLine("value before is {0}", mySValue)  
        Dim myTrueString As String = "true"  
  
        ' Use SetExpression to set the value to true.  
myConnMgr.Properties("RetainSameConnection").SetExpression(myConnMgr, myTrueString)  
  
        ' Validate the package to set the expression on the property.  
        Dim valResult As DTSExecResult = pkg.Validate(myConns, Nothing, Nothing, Nothing)  
  
        ' Now that the value has been set, retrieve the value  
        ' and the expression.  
        myValue = myConnMgr.Properties("RetainSameConnection").GetValue(myConnMgr)  
        mySValue = myValue.ToString()  
        Dim myExpression As String = myConnMgr.Properties("RetainSameConnection").GetExpression(myConnMgr)  
        Dim mySExpression As String = myExpression.ToString()  
        Console.WriteLine("value and expression is {0}, {1}", mySValue, mySExpression)   
        End Sub  
    End Class  
End Namespace  

示例输出:Sample Output:

有 RetainSameConnection?has RetainSameConnection? TrueTrue

之前的值为 Falsevalue before is False

值和表达式为 True,truevalue and expression is True, true

Remarks

propertyName可以是对象上可用的任何属性。The propertyName can be any property available on the object.

Applies to