DTSPackageType Enumeration in SSIS Package properties

Identifies the tool that created the package.


SYNTAX IN VB:

'Declaration

Public Enumeration DTSPackageType

'Usage

Dim instance As DTSPackageType

SYNTAX IN C#:
public enum DTSPackageType


SYNTAX IN C++:

public enum class DTSPackageType
SYNTAX IN JScript:


public enum DTSPackageType
MEMBERS




Member name
Description
Default
Undefined.
DTSWizard
Specifies that the package was created by the SQL Server Import and Export Wizard.
DTSDesigner
Specifies that the package was created in the designer in SQL Server 2000.
SQLReplication
Specifies that the package was generated to support transformable subscriptions.
DTSDesigner100
Specifies that the package was created in SSIS Designer in SQL Server 2008 Integration Services (SSIS).
SQLDBMaint
Specifies that the DBMaint client created the package.
EXAMPLES:
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.

In VB:
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
In C#:
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    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\SmoTablesDBCC\SmoTablesDBCC\SmoTablesDBCC.dtsx", null);
            
            // Display the package type.
            Console.WriteLine("The package type is: {0}", pkg.PackageType);
        }
    }
}
Sample Output:
The package type is: DTSDesigner100