Export (0) Print
Expand All

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)

type DTSPackageType

Member nameDescription



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


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


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


Specifies that the DBMaint client created the package.


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.

No code example is currently available or this language may not be supported.

Sample Output:

The package type is: DTSDesigner100

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

Community Additions

© 2015 Microsoft