Package.SetExpression(String, String) Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menetapkan ekspresi yang ditentukan ke properti . Tentukan null untuk menghapus ekspresi yang ada dari properti .

public:
 virtual void SetExpression(System::String ^ propertyName, System::String ^ expression);

public void SetExpression (string propertyName, string expression);

abstract member SetExpression : string * string -> unit
override this.SetExpression : string * string -> unit

Public Sub SetExpression (propertyName As String, expression As String)

Parameter

propertyName

String

Nama properti yang akan ditetapkan ekspresinya.

expression

String

Ekspresi.

Penerapan

SetExpression(String, String)

Contoh

Contoh kode berikut memodifikasi nilai DelayValidation properti menggunakan SetExpression, lalu menampilkan nilai baru menggunakan GetExpression.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package pkg = new Package();  
            // Set an expression on one of the properties.  
            DtsProperties pkgProperties = pkg.Properties;  

            // View information about the DelayValidation property   
            // before setting it with the SetExpression method.  
            Object myValue = pkgProperties["DelayValidation"].GetValue(pkg);  
            String mySValue = myValue.ToString();  
            Console.WriteLine("value before is {0}", mySValue);   

            // Use SetExpression to set the value to true.  
            String myTrueString = "true";  
            pkgProperties["DelayValidation"].SetExpression(pkg, myTrueString);  

            // Validate the package to set the expression onto the property.  
            DTSExecResult valResult = pkg.Validate(null, null, null, null);  

            // Verify the new setting.  
            myValue = pkgProperties["DelayValidation"].GetValue(pkg);  
            mySValue = myValue.ToString();  

            String myExpression = pkg.Properties["DelayValidation"].GetExpression(pkg);  
            String mySExpression = myExpression.ToString();  
            Console.WriteLine("The value and expression is {0}, {1}", mySValue, mySExpression);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Class Program  
    Shared Sub Main(ByVal args() As String)   
        Dim pkg As New Package()  
        ' Set an expression on one of the properties.  
        Dim pkgProperties As DtsProperties = pkg.Properties  

        ' View information about the DelayValidation property   
        ' before setting it with the SetExpression method.  
        Dim myValue As [Object] = pkgProperties("DelayValidation").GetValue(pkg)  
        Dim mySValue As String = myValue.ToString()  
        Console.WriteLine("value before is {0}", mySValue)  

        ' Use SetExpression to set the value to true.  
        Dim myTrueString As String = "true"  
        pkgProperties("DelayValidation").SetExpression(pkg, myTrueString)  

        ' Validate the package to set the expression onto the property.  
        Dim valResult As DTSExecResult = pkg.Validate(Nothing, Nothing, Nothing, Nothing)  

        ' Verify the new setting.  
        myValue = pkgProperties("DelayValidation").GetValue(pkg)  
        mySValue = myValue.ToString()  

        Dim myExpression As String = pkg.Properties("DelayValidation").GetExpression(pkg)  
        Dim mySExpression As String = myExpression.ToString()  
        Console.WriteLine("The value and expression is {0}, {1}", mySValue, mySExpression)  
    End Sub  
End Class  

Contoh Output:

value before is False

The value and expression is True, true

Keterangan

propertyName dapat berupa properti apa pun yang tersedia pada objek .