Package.GetExpression(String) Método

Definição

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Retorna um valor que contém a expressão da propriedade especificada. Nulo significa que nenhuma expressão é atribuída.

public:
 virtual System::String ^ GetExpression(System::String ^ propertyName);

public string GetExpression (string propertyName);

abstract member GetExpression : string -> string
override this.GetExpression : string -> string

Public Function GetExpression (propertyName As String) As String

Parâmetros

propertyName

String

O nome da propriedade cuja expressão você deseja ver.

Retornos

String

Um valor que contém a expressão usada para avaliar a propriedade.

Implementações

GetExpression(String)

Exemplos

O exemplo de código a DelayValidation seguir modifica o valor da propriedade usando SetExpressione exibe o novo valor usando 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  

Saída de exemplo:

value before is False

The value and expression is True, true

Comentários

Pode propertyName ser qualquer propriedade disponível no objeto.