Package.ExtendedProperties 속성
Gets the ExtendedProperties collection for the package.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
<BrowsableAttribute(False)> _
Public ReadOnly Property ExtendedProperties As ExtendedProperties
Get
‘사용 방법
Dim instance As Package
Dim value As ExtendedProperties
value = instance.ExtendedProperties
[BrowsableAttribute(false)]
public ExtendedProperties ExtendedProperties { get; }
[BrowsableAttribute(false)]
public:
property ExtendedProperties^ ExtendedProperties {
ExtendedProperties^ get ();
}
[<BrowsableAttribute(false)>]
member ExtendedProperties : ExtendedProperties
function get ExtendedProperties () : ExtendedProperties
속성 값
유형: Microsoft.SqlServer.Dts.Runtime.ExtendedProperties
The ExtendedProperties object collection for the package.
예
The following code example shows some of the extended properties in the package.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.ScriptTask;
namespace Package_API
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
Package pkg = new Package();
pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);
// Get the extended properties.
ExtendedProperties extProps = pkg.ExtendedProperties;
// Iterate through the extended properties.
foreach (ExtendedProperty exProp in extProps)
{
Console.WriteLine("{0}, {1}", exProp.ID, exProp.DataType);
Console.WriteLine("--------------------------------");
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.ScriptTask
Namespace Package_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim pkg As Package = New Package()
pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)
' Get the extended properties.
Dim extProps As ExtendedProperties = pkg.ExtendedProperties
' Iterate through the extended properties.
Dim exProp As ExtendedProperty
For Each exProp In extProps
Console.WriteLine("{0}, {1}", exProp.ID, exProp.DataType)
Console.WriteLine("--------------------------------")
Next
End Sub
End Class
End Namespace
Sample Output:
{4CBE9BFD-9218-4027-A1EA-EF3BAB585B99}, String
--------------------------------
{F50BF3C3-4077-479B-A946-CDC297ADC5D3}, String
--------------------------------
{89E1F3B4-935E-4221-8BD3-36251C853180}, String
--------------------------------
{74E2710F-B94C-4D18-8531-0C0A7D906924}, String
--------------------------------
{9C863EB8-B14D-4A73-B95E-1FB1A7348F40}, String
--------------------------------
{6AE87DC6-FEDC-458B-AEFC-61BCA27FE2CF}, String
--------------------------------
{D667DF92-65D7-4468-8B75-FFDB2206B911}, String
--------------------------------