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

DTSFileConnectionUsageType Enumeration

SQL Server 2012

Provides information about how a connection is used by a component client.

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

public enum DTSFileConnectionUsageType

	Member name	Description
	CreateFile	Creates a file. The option creates the file only if it does not already exist.
	CreateFolder	Creates a folder.
	FileExists	The file exists.
	FolderExists	The folder exists.

This enumeration is used by the connection manager for validation purposes. For example, if the connection is being used to delete a file, and the connection is pointing to a folder, it fails validation. In addition, this enumerator indicates to the connection manager whether ambiguous names are files or folders. For example, "C:\ABC" could be the name of a new folder, or it could be a new file in the C:\ directory. This enumeration indicates if it is a file or folder.

The following code example creates a package and adds a FILE ConnectionManager. The DTSFileConnectionUsageType enumeration describes the FileUsageType property as being an existing file by specifying the FileExists value.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class mySqlServer_Sample
    {
        static void Main(string[] args)
        {
            Package package = new Package();
            ConnectionManager cm_srcDirectory = package.Connections.Add("FILE");
            cm_srcDirectory.Name = "cm_srcDirectory";
            cm_srcDirectory.ConnectionString =  @"C:\MyFTPDirectory\*.*";
            cm_srcDirectory.Properties["FileUsageType"].SetValue(cm_srcDirectory, DTSFileConnectionUsageType.FileExists);
        }
    }
}

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.