DTSPackageType Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

Identifies the tool that created the package.

public enum class DTSPackageType
public enum DTSPackageType
type DTSPackageType = 
Public Enum DTSPackageType
Inheritance
Enum
DTSPackageType

Fields

Name Value Description
Default 0

Undefined.
DTSWizard 1

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

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

Specifies that the package was generated to support transformable subscriptions.
DTSDesigner100 5

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

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.

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

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

Applies to