United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

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

DTSProviderType Enumeration

SQL Server 2012

SQL Server 2005

Describes the kind of provider that is stored.

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

public enum DTSProviderType

	Member name	Description
	DtsDestination	The provider is a destination.
	DtsSource	The provider is a source of data.
	Odbc	The provider is an ODBC provider.
	OleDb	The provider is an OLEDB provider.
	Unknown	The provider is of an unknown type.

This enumeration is used by the DBProviderInfo class, in the ProviderType property, to indicate what kind of provider the class contains.

The following example enumerates the properties of the database providers available on the computer including the DTSProviderType.

namespace dbproviderinfo
{
    class Program
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            DBProviderInfos dbis = app.DBProviderInfos;
            foreach (DBProviderInfo dbi in dbis)
            {
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName);
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType);
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName);
            }
        }
    }
}

Sample output:

Description = MediaCatalogDB OLE DB Provider, Name = MediaCatalogDB OLE DB Provider, ParseName = {09E767A6-4481-4791-86A5-A739E5290E4C}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Description = Microsoft OLE DB Provider for SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

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. All rights reserved.

|

Site Feedback

© 2013 Microsoft. All rights reserved.