Export (0) Print
Expand All
Expand Minimize

DTSPackageType Enumeration

Identifies the tool that created the package.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Public Enumeration DTSPackageType
Dim instance As DTSPackageType

Member nameDescription
DTSDesignerSpecifies that the package was created in the designer in SQL Server 2000.
DTSDesigner100Specifies that the package was created in SSIS Designer in SQL Server 2008 Integration Services (SSIS).
DTSWizardSpecifies that the package was created by the SQL Server Import and Export Wizard.
SQLDBMaintSpecifies that the DBMaint client created the package.
SQLReplicationSpecifies that the package was generated to support transformable subscriptions.

The following code example loads one of the Integration Services package samples, and displays its package type, which is one of the values from this enumeration.

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Microsoft.SqlServer.SSIS.Samples
    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\SmoTablesDBCC\SmoTablesDBCC\SmoTablesDBCC.dtsx", Nothing)
            ' Display the package type.
            Console.WriteLine("The package type is: {0}", pkg.PackageType)
        End Sub
    End Class
End Namespace

Sample Output:

The package type is: DTSDesigner100

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft