ConnectionManager.GetExpression(String) 메서드

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

지정된 속성에 대한 식이 들어 있는 String을 반환합니다. Null은 식이 할당되지 않음을 의미합니다.

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

매개 변수

propertyName

String

해당 식을 확인하려는 속성의 이름입니다.

반환

String

속성을 평가하는 데 사용되는 식을 포함하는 문자열입니다.

구현

GetExpression(String)

예제

다음 코드 예제에서는 연결 관리자의 고유 속성에 식을 설정한 다음 패키지의 유효성을 검사한 후 검색합니다.

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  

샘플 출력:

RetainSameConnection이 있나요? 참

이전 값은 False입니다.

value 및 expression is True, true

설명

propertyName 연결 문자열, 설명, 이름 또는 보호 수준일 수 있습니다. 연결 관리자의 경우 현재 식을 지원하는 유일한 속성입니다.

이러한 일반적인 연결 관리자 속성 외에도 각 연결 형식에는 고유한 속성이 있습니다. 이러한 속성은 컬렉션에 Properties 의해 나열됩니다.