DtsProperty.GetValue(Object) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns the value of the property.

public:
 System::Object ^ GetValue(System::Object ^ o);

public object GetValue (object o);

member this.GetValue : obj -> obj

Public Function GetValue (o As Object) As Object

Parameters

o: Object

The parent object of the property whose value is to be returned.

Returns

Object

An object that contains the value of the property.

Examples

using System;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace DtsPropertyGetValueCS  
{  
  class Program  
  {  
    static void Main(string[] args)  
    {  
      Package testPackage;  
      ConnectionManager testConnection;  
      DtsProperty testProperty;  
      string propertyValue;  

      testPackage = new Package();  
      testConnection = testPackage.Connections.Add("OLEDB");  
      testConnection.ConnectionString = "Provider=SQLOLEDB;" +  
        "Data Source=(local);Initial Catalog=AdventureWorks;" +  
        "Integrated Security=SSPI";  
      testConnection.Name = "Test Connection Manager";  

      testProperty = testConnection.Properties["ServerName"];  
      propertyValue = testProperty.GetValue(testConnection).ToString();  

      Console.WriteLine("The value of ServerName is: " + propertyValue);  
      Console.Read();  

    }  
  }  
}

Imports Microsoft.SqlServer.Dts.Runtime  

Module Module1  

  Sub Main()  

    Dim testPackage As Package  
    Dim testConnection As ConnectionManager  
    Dim testProperty As DtsProperty  
    Dim propertyValue As String  

    testPackage = New Package()  
    testConnection = testPackage.Connections.Add("OLEDB")  
    testConnection.ConnectionString = "Provider=SQLOLEDB;" & _  
      "Data Source=(local);Initial Catalog=AdventureWorks;" & _  
      "Integrated Security=SSPI"  
    testConnection.Name = "Test Connection Manager"  

    testProperty = testConnection.Properties("ServerName")  
    propertyValue = testProperty.GetValue(testConnection).ToString()  

    Console.WriteLine("The value of ServerName is: " & propertyValue)  
    Console.Read()  

  End Sub  

End Module

Remarks

When you request the value of a property by calling the GetValue method, the object that you must pass as a parameter is the object to which the property belongs. For example, if you are working with an OLE DB connection manager as shown in the following example, and you have created a DtsProperty object for its ServerName property, then you would pass the connection manager object as the parameter to the GetValue method.

Applies to

Share via