Package.PackageType Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Especifica un valor que identifica la herramienta que creó el paquete.

public:
 property Microsoft::SqlServer::Dts::Runtime::DTSPackageType PackageType { Microsoft::SqlServer::Dts::Runtime::DTSPackageType get(); void set(Microsoft::SqlServer::Dts::Runtime::DTSPackageType value); };

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryIdentification")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PackageTypeDesc")]
public Microsoft.SqlServer.Dts.Runtime.DTSPackageType PackageType { get; set; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryIdentification")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PackageTypeDesc")>]
member this.PackageType : Microsoft.SqlServer.Dts.Runtime.DTSPackageType with get, set

Public Property PackageType As DTSPackageType

Valor de propiedad

DTSPackageType

Especifica un valor que identifica la herramienta que creó el paquete.

Atributos

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Ejemplos

En el ejemplo de código siguiente se muestra el tipo de paquete de uno de los paquetes de ejemplo de SSIS.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

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);  

            // Show the package type  
            Console.WriteLine("The package type is {0}", pkg.PackageType);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

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)  

            ' Show the package type  
            Console.WriteLine("The package type is {0}", pkg.PackageType)  
        End Sub  
    End Class  
End Namespace  

Salida del ejemplo:

The package type is Default

Comentarios

Si el paquete se crea mediante el Diseñador de SSIS, el valor predeterminado es DTSDesigner100.