SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Integration Services)

Microsoft.SqlServer.Dts.Runtime

ActionOnExistType Enumeration

Application Class

BatchUpgradeOptions Class

BreakpointManager Class

BreakpointTarget Class

BreakpointTargetEnumerator Class

BreakpointTargets Class

Configuration Class

ConfigurationEnumerator Class

Configurations Class

ConnectionEnumerator Class

ConnectionInfo Class

ConnectionInfoEnumerator Class

ConnectionInfos Class

ConnectionManager Class

ConnectionManagerBase Class

ConnectionManagerItem Class

ConnectionManagerItems Class

ConnectionManagerItemState Enumeration

Connections Class

DataTypeInfo Class

DataTypeInfoEnumerator Class

DataTypeInfos Class

DBProviderInfo Class

DBProviderInfoEnumerator Class

DBProviderInfos Class

DefaultEvents Class

DTSBreakpointHitTest Enumeration

DTSCheckpointUsage Enumeration

DtsComException Class

DtsComponentException Class

DTSConfigurationType Enumeration

DtsConnectionAttribute Class

DtsConnectionException Class

DTSConnectionManagerScope Enumeration

DtsContainer Class

DtsConvert Class

DtsCouldNotCreateManagedConnectionException Class

DtsCouldNotCreateManagedForEachEnumeratorException Class

DtsEnumerator Class

DtsErrors Class

DTSEventColumnFilter Structure

DTSEventFilterKind Enumeration

DtsEventHandler Class

DtsEventHandlerEnumerator Class

DtsEventHandlers Class

DtsException Class

DTSExecResult Enumeration

DTSExecStatus Enumeration

DTSExecutionLocation Enumeration

DtsExponentTooLargeException Class

DTSFileConnectionUsageType Enumeration

DTSForcedExecResult Enumeration

DtsForEachEnumeratorAttribute Class

DtsGenericException Class

DtsInvalidBreakpointSiteException Class

DtsInvalidProjectPasswordOrDataException Class

DtsInvalidProjectUserKeyOrDataException Class

DTSLogEntryFrequency Enumeration

DTSLoggingMode Enumeration

DtsLogProviderAttribute Class

DTSManagedXmlSerializationHelper Class

DtsNoConnectionAssignedException Class

DtsNoForEachEnumAssignedException Class

DtsNoLogProviderAssignedException Class

DtsNoObjectAssignedException Class

DtsNotAConnectionException Class

DtsNotAForEachEnumException Class

DtsNotALogProviderException Class

DtsNotAManagedEnumeratorException Class

DtsNoTaskAssignedException Class

DtsNotATaskException Class

DtsObject Class

DTSObjectHostType Enumeration

DTSObjectReferenceType Enumeration

DTSPackageInfoFlags Enumeration

DTSPackageType Enumeration

DTSPipelineComponentType Enumeration

DtsPipelineException Class

DTSPrecedenceEvalOp Enumeration

DTSPriorityClass Enumeration

DTSProductLevel Enumeration

DtsProperties Class

DtsProperty Class

DtsPropertyAttribute Class

DTSPropertyKind Enumeration

DTSProtectionLevel Enumeration

DTSProviderSubType Enumeration

DTSProviderType Enumeration

DTSReadOnlyCollectionBase Class

DtsRuntimeException Class

DtsScriptingException Class

DTSServerParameterType Enumeration

DTSSignatureStatus Enumeration

DtsSqlException Class

DtsTaskAttribute Class

DtsTaskException Class

DtsToolsException Class

DTSTransactionOption Enumeration

DtsWarning Class

DtsWarnings Class

EmptyEnumerator Class

EnumReferencedObjects Class

ErrorEnumerator Class

EventInfo Class

EventInfoEnumerator Class

EventInfos Class

EventsProvider Class

Executable Class

ExecutableEnumerator Class

Executables Class

ExtendedProperties Class

ExtendedProperty Class

ExtendedPropertyEnumerator Class

FlatFileColumn Class

ForEachEnumerator Class

ForEachEnumeratorHost Class

ForEachEnumeratorInfo Class

ForEachEnumeratorInfos Class

ForEachEnumeratorInfosEnumerator Class

ForEachEnumeratorUI Class

ForEachLoop Class

ForEachVariableMapping Class

ForEachVariableMappingEnumerator Class

ForEachVariableMappings Class

ForLoop Class

FtpClientConnection Class

HttpClientConnection Class

IDTSBreakpointSite Interface

IDTSComponentEvents Interface

IDTSComponentPersist Interface

IDTSConfigurationControl Interface

IDTSDowngradableObject Interface

IDTSDumpConfiguration Interface

IDTSEvents Interface

IDTSExecutionMetrics Interface

IDTSExecutionPath Interface

IDTSForEachEnumerator Interface

IDTSForEachEnumeratorUI Interface

IDTSInfoEvents Interface

IDTSLogging Interface

IDTSManagedTask Interface

IDTSName Interface

IDTSObjectHost Interface

IDTSPackageInternal Interface

IDTSPackagePath Interface

IDTSPersist Interface

IDTSPropertiesProvider Interface

IDTSPropertiesProviderEx Interface

IDTSSequence Interface

IDTSSuspend Interface

LogEntryInfo Class

LogEntryInfoEnumerator Class

LogEntryInfos Class

LoggingOptions Class

LogProvider Class

LogProviderBase Class

LogProviderEnumerator Class

LogProviderInfo Class

LogProviderInfoEnumerator Class

LogProviderInfos Class

LogProviders Class

ManagedForEachEnumeratorWrapper Class

ManagedHelper Class

ManagedHelper.ManagedPropertyHelper Class

ManagedWrapper Class

ManagerSerializer Class

NameChecker Class

NameCheckResult Enumeration

ObjectReferenceTracker Class

Package Class

PackageInfo Class

PackageInfoEnumerator Class

PackageInfos Class

PackageItem Class

PackageItems Class

PackageItemState Enumeration

PackageParameterEnumerator Class

PackageUpgradeOptions Class

PackageUpgradeResult Class

Parameter Class

ParameterInfo Class

ParameterInfos Class

Parameters Class

PipelineComponentInfo Class

PipelineComponentInfoEnumerator Class

PipelineComponentInfos Class

PrecedenceConstraint Class

PrecedenceConstraintEnumerator Class

PrecedenceConstraints Class

Project Class

Project.AccessMode Enumeration

ProjectStorageAttributes Enumeration

ProjectVariablesWrapper Class

PropertyEnumerator Class

RunningPackage Class

RunningPackages Class

RunningPackagesEnumerator Class

SelectedLogProviders Class

SsisServerExecution Class

StatusMessage Structure

StorageInfo Class

StorageType Enumeration

Task Class

TaskInfoEnumerator Class

TaskInfos Class

UpgradePackageInfo Class

UpgradeResult Class

UpgradeResultStatus Enumeration

VariableDispenser Class

VariableEnumerator Class

Variables Class

WarningEnumerator Class

Minimize

This topic has not yet been rated - Rate this topic

DTSPackageType Enumeration

SQL Server 2012

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 name	Description
	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.

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

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.