DTSPackageType Enumeration

Identifies the tool that created the package.

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

public enum DTSPackageType
public enum DTSPackageType
public enum DTSPackageType

Member nameDescription
DTSDesignerSpecifies that the package was created in the designer in SQL Server 2000.
DTSDesigner90Specifies that the package was created in the SSIS Designer in SQL Server 2005 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.

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\90\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: DTSDesigner90

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions