Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DTSPackageType Enumeration

 

Applies To: SQL Server 2016 Preview

Identifies the tool that created the package.

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

public enum DTSPackageType

Member nameDescription
Default

Undefined.

DTSDesigner

Specifies that the package was created in the designer in SQL Server 2000.

DTSDesigner100

Specifies that the package was created in SSIS Designer in SQL Server 2008 Integration Services (SSIS).

DTSWizard

Specifies that the package was created by the SQL Server Import and Export Wizard.

SQLDBMaint

Specifies that the DBMaint client created the package.

SQLReplication

Specifies that the package was generated to support transformable subscriptions.

Legacy Code Example

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\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

Return to top

Community Additions

Show:
© 2015 Microsoft