DTSFileConnectionUsageType Enumeration

 

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 class DTSFileConnectionUsageType

Member nameDescription
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.

No code example is currently available or this language may not be supported.
Return to top
Show: