Package.ExtendedProperties Proprietà
Definizione
Importante
Alcune informazioni sono relative alla release non definitiva del prodotto, che potrebbe subire modifiche significative prima della release definitiva. Microsoft non riconosce alcuna garanzia, espressa o implicita, in merito alle informazioni qui fornite.
Ottiene la raccolta ExtendedProperties per il pacchetto.
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
Valore della proprietà
Raccolta di oggetti ExtendedProperties per il pacchetto.
- Attributi
Esempio
Nell'esempio di codice seguente vengono illustrate alcune delle proprietà estese nel pacchetto.
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
Esempio di 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
--------------------------------