Package.ExtendedProperties Properti
Definisi
Penting
Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.
ExtendedProperties Mendapatkan koleksi untuk paket.
public:
property Microsoft::SqlServer::Dts::Runtime::ExtendedProperties ^ ExtendedProperties { Microsoft::SqlServer::Dts::Runtime::ExtendedProperties ^ get(); };
[System.ComponentModel.Browsable(false)]
public Microsoft.SqlServer.Dts.Runtime.ExtendedProperties ExtendedProperties { get; }
[<System.ComponentModel.Browsable(false)>]
member this.ExtendedProperties : Microsoft.SqlServer.Dts.Runtime.ExtendedProperties
Public ReadOnly Property ExtendedProperties As ExtendedProperties
Nilai Properti
Koleksi ExtendedProperties objek untuk paket.
- Atribut
Contoh
Contoh kode berikut menunjukkan beberapa properti yang diperluas dalam paket.
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
Contoh 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
--------------------------------