Metodo Sequence.GetExpression

Returns a String that contains the expression for the specified property. Null means no expression is assigned.

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
Public Function GetExpression ( _
    propertyName As String _
) As String
'Utilizzo
Dim instance As Sequence 
Dim propertyName As String 
Dim returnValue As String 

returnValue = instance.GetExpression(propertyName)

public string GetExpression(
    string propertyName
)

public:
virtual String^ GetExpression(
    String^ propertyName
) sealed

abstract GetExpression : 
        propertyName:string -> string  
override GetExpression : 
        propertyName:string -> string

public final function GetExpression(
    propertyName : String
) : String

Parametri

• propertyName
  Tipo: System.String
  The name of the property whose expression you want to see.

Valore restituito

Tipo: System.String
A String that contains the expression used to evaluate the property.

Implementa

IDTSPropertiesProvider.GetExpression(String)

Osservazioni

The propertyName can be any property available on the object.

Esempi

The following code example uses SetExpression to modify the value of the Description on a Sequence container. Then GetExpression is used to retrieve the expression.

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

namespace Microsoft.SqlServer.SSIS.Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            const String containerName = "Sequence";
            Package pkg = new Package();
            Sequence sequence = (Sequence)pkg.Executables.Add("STOCK:Sequence");
            DtsProperties seqProps = sequence.Properties;

            // View information about the Description property
            // before setting it using the SetExpression method.
            String desc = sequence.Description;
            Console.WriteLine("Original value of Description: {0}", desc);

            // Use SetExpression to give the Sequence a description.
            String myExpression = "\"Testing " + containerName + "\""; 
            sequence.SetExpression("Description", myExpression);
            // Note that I've tried using the Properties bag instead, with no change to the results.
            //seqProps["Description"].SetExpression(sequence, myExpression); 

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

            // Retrieve the new value and the expression.
            String myNewDesc = sequence.Description;
            String myNewExpression = sequence.GetExpression("Description");
            Console.WriteLine("New value of Description: {0}", myNewDesc);
            Console.WriteLine("Expression for Description: {0}", myNewExpression);
        }
    }
}

Sample Output:

Original value of Description:

New value of Description: Testing Sequence

Expression for Description: "Testing Sequence"

Vedere anche

Riferimento

Sequence Classe

Spazio dei nomi Microsoft.SqlServer.Dts.Runtime