Enumerated Constants in Property Expressions

If property expressions include values from an enumerator member list, the expression must use the numeric value of the enumerator member instead of the friendly name of the member. For example, if an expression sets the LoggingMode property then you must use the numeric value 2 instead of the friendly name Disabled.

This topic lists only the numeric values equivalent to friendly names of enumerators whose members are commonly used in property expressions. The Integration Services object model includes many additional enumerators that you use when you program the object model to build packages programmatically or code custom package elements such as tasks and data flow components.

In addition to the custom properties for packages and package objects, the Properties window in SQL Server Data Tools (SSDT) includes a set of properties that are available to packages, tasks, and the Foreach Loop, For Loop, and Sequence containers. The common properties that are set by values from enumerators—ForceExecutionResult, LoggingMode, IsolationLevel, and Transaction Option—are listed in Common Properties section.

The following sections provide information about enumerated constants:

Package

Foreach Loop Enumerators

Tasks

Maintenance Plan Tasks

Common Properties

Package

The following tables lists the friendly names and the numeric value equivalents for properties of packages that you set by using values from an enumerator.

PackageType property—Set by using values from the DTSPackageType enumeration.

Friendly name in DTSPackageType Numeric value
Default 0
DTSWizard 1
DTSDesigner 2
SQLReplication 3
DTSDesigner100 5
SQLDBMaint 6

CheckpointUsage property—Set by using values from the DTSCheckpointUsage enumeration.

Friendly name in DTSCheckpointUsage Numeric value
Never 0
IfExists 1
Always 2

PackagePriorityClass property—Set by using values from the DTSPriorityClass enumeration.

Friendly name in DTSPriorityClass Numeric value
Default 0
AboveNormal 1
Normal 2
BelowNormal 3
Idle 4

ProtectionLevel property—Set by using values from the DTSProtectionLevel enumeration.

Friendly name in DTSProtectionLevel Numeric value
DontSaveSensitive 0
EncryptSensitiveWithUserKey 1
EncryptSensitiveWithPassword 2
EncryptAllWithPassword 3
EncryptAllWithUserKey 4
ServerStorage 5

Precedence Constraints

EvalOp property—Set by using values from the DTSPrecedenceEvalOp enumeration.

Friendly name in DTSPrecedenceEvalOp Numeric value
Expression 1
Constraint 2
ExpressionAndConstraint 3
ExpressionOrConstraint 4

Value property—Set by using values from the DTSExecResult enumeration.

Friendly Name Numeric Value
Success 0
Failure 1
Completion 2
Canceled 3

Foreach Loop Enumerators

The Foreach Loop includes a set of enumerators with properties that can be set by property expressions.

Foreach ADO Enumerator

Type property—Set by using values from the ADOEnumerationType enumeration.

Friendly name in ADOEnumerationType Numeric value
EnumerateTables 0
EnumerateAllRows 1
EnumerateRowsInFirstTable 2

Foreach Nodelist Enumerator

SourceDocumentType, InnerXPathStringSourceType, and OuterXPathStringSourceType properties—Set by using values from the SourceType enumeration.

Friendly name in SourceType Numeric value
FileConnection 0
Variable 1
DirectInput 2

EnumerationType property—Set by using values from the EnumerationType enumeration.

Friendly name in EnumerationType Numeric value
Navigator 0
Node 1
NodeText 2
ElementCollection 3

InnerElementType property—Set by using values from the InnerElementType enumeration.

Friendly name in InnerElementType Numeric value
Navigator 0
Node 1
NodeText 2

Tasks

Integration Services includes numerous tasks with properties that can be set by property expressions.

Analysis Services Execute DDL Task

SourceType property—Set by using values from the DDLSourceType enumeration.

Friendly name in DDLSourceType Numeric value
DirectInput 0
FileConnection 1
Variable 2

Bulk Insert Task

DataFileType property—Set by using values from the DTSBulkInsert_DataFileType enumeration.

Friendly name in DTSBulkInsert_DataFileType Numeric value
DTSBulkInsert_DataFileType_Char 0
DTSBulkInsert_DataFileType_Native 1
DTSBulkInsert_DataFileType_WideChar 2
DTSBulkInsert_DataFileType_WideNative 3

Execute SQL Task

ResultSetType property—Set by using values from the ResultSetType enumeration.

Friendly name in ResultSetType Numeric Value
ResultSetType_None 1
ResultSetType_SingleRow 2
ResultSetType_Rowset 3
ResultSetType_XML 4

SqlStatementSourceType property—Set by using values from the SqlStatementSourceType enumeration.

Friendly name in SqlStatementSourceType Numeric Value
DirectInput 1
FileConnection 2
Variable 3

File System Task

Operation property—Set by using values from the DTSFileSystemOperation enumeration.

Friendly name in DTSFileSystemOperation Numeric value
CopyFile 0
MoveFile 1
DeleteFile 2
RenameFile 3
SetAttributes 4
CreateDirectory 5
CopyDirectory 6
MoveDirectory 7
DeleteDirectory 8
DeleteDirectoryContent 9

Attributes property—Set by using values from the DTSFileSystemAttributes enumeration.

Friendly name in DTSFileSystemAttributes Numeric value
Normal 0
Archive 1
Hidden 2
ReadOnly 4
System 8

FTP Task

Operation property—Set by using values from the DTSFTPOp enumeration.

Friendly name in DTSFTPOp Numeric value
Send 0
Receive 1
DeleteLocal 2
DeleteRemote 3
MakeDirLocal 4
MakeDirRemote 5
RemoveDirLocal 6
RemoveDirRemote 7

Message Queue Task

MessageType property—Set by using values from the MQMessageType enumeration.

Friendly name in MQMessageType Numeric value
DTSMQMessageType_String 0
DTSMQMessageType_DataFile 1
DTSMQMessageType_Variables 2
DTSMQMessagType_StringMessageToVariable 3

StringCompareType property—Set by using values from the MQStringMessageCompare enumeration.

Friendly name in MQStringMessageCompare Numeric value
DTSMQStringMessageCompare_None 0
DTSMQStringMessageCompare_Exact 1
DTSMQStringMessageCompare_IgnoreCase 2
DTSMQStringMessageCompare_Contains 3

TaskType property—Set by using values from the MQType enumeration.

Friendly name in MQType Numeric value
DTSMQType_Sender 0
DTSMQType_Receiver 1

Send Mail Task

MessageSourceType property—Set by using values from the SendMailMessageSourceType enumeration.

Friendly Name in SendMailMessageSourceType Numeric Value
DirectInput 0
FileConnection 1
Variable 2

Priority property—Set by using values from the MailPriority enumeration.

Friendly Name in MailPriority Numeric Value
High 1
Normal 3
Low 5

Transfer Database Task

Action property—Set by using values from the TransferAction enumeration.

Friendly name in TransferAction Numeric value
Copy 0
Move 1

Method property—Set by using values from the TransferMethod enumeration.

Friendly name in TransferMethod Numeric value
DatabaseOffline 0
DatabaseOnline 1

Transfer Error Messages Task

IfObjectExists property—Set by using values from the IfObjectExists enumeration.

Friendly Name in IfObjectExists Numeric value
FailTask 0
Overwrite 1
Skip 2

Transfer Jobs Task

IfObjectExists property—Set by using values from the IfObjectExists enumeration.

Friendly Name in IfObjectExists Numeric value
FailTask 0
Overwrite 1
Skip 2

Transfer Logins Task

IfObjectExists property—Set by using values from the IfObjectExists enumeration.

Friendly name in IfObjectExists Numeric value
FailTask 0
Overwrite 1
Skip 2

LoginsToTransfer property—Set by using values from the LoginsToTransfer enumeration.

Friendly name in LoginsToTransfer Numeric value
AllLogins 0
SelectedLogins 1
AllLoginsFromSelectedDatabases 2

Transfer Master Stored Procedures Task

IfObjectExists property—Set by using values from the IfObjectExists enumeration.

Friendly name in IfObjectExists Numeric value
FailTask 0
Overwrite 1
Skip 2

Transfer SQL Server Objects Task

ExistingData property—Set by using values from the ExistingData enumeration.

Friendly name in ExistingData Numeric Value
Replace 0
Append 1

Web Service Task

OutputType property—Set by using values from the DTSOutputType enumeration.

Friendly name in DTSOutputType Numeric value
File 0
Variable 1

WMI Data Reader Task

OverwriteDestination property—Set by using values from the OverwriteDestination enumeration.

Friendly name in OverwriteDestination Numeric value
OverwriteDestination 0
AppendToDestination 1
KeepOriginal 2

OutputType property—Set by using values from the OutputType enumeration.

Friendly name in OutputType Numeric value
DataTable 0
PropertyValue 1
PropertyNameAndValue 2

DestinationType property—Set by using values from the DestinationType enumeration.

Friendly name in DestinationType Numeric value
FileConnection 0
Variable 1

WqlQuerySourceType property—Set by using values from the QuerySourceType enumeration.

Friendly Name in QuerySourceType Numeric Value
FileConnection 0
DirectInput 1
Variable 2

WMI Event Watcher ActionAtEvent property—Set by using values from the ActionAtEvent enumeration.

Friendly Name in ActionAtEvent Numeric Value
LogTheEventAndFireDTSEvent 0
LogTheEvent 1

ActionAtTimeout property—Set by using values from the ActionAtTimeout enumeration.

Friendly name in ActionAtTimeout Numeric value
LogTimeoutAndFireDTSEvent 0
LogTimeout 1

AfterEvent property—Set by using values from the AfterEvent enumeration.

Friendly name in AfterEvent Numeric value
ReturnWithSuccess 0
ReturnWithFailure 1
WatchfortheEventAgain 2

AfterTimeout property—Set by using values from the AfterTimeout enumeration.

Friendly name in AfterTimeout Numeric value
ReturnWithSuccess 0
ReturnWithFailure 1
WatchfortheEventAgain 2

WqlQuerySourceType property—Set by using values from the QuerySourceType enumeration.

Friendly name in QuerySourceType Numeric value
FileConnection 0
DirectInput 1
Variable 2

XML Task

OperationType property—Set by using values from the DTSXMLOperation enumeration.

Friendly name in DTSXMLOperation Numeric value
Validate 0
XSLT 1
XPATH 2
Merge 3
Diff 4
Patch 5

SourceType, SecondOperandType, and XPathSourceType properties—Set by using values from the DTSXMLSourceType enumeration.

Friendly name in DTSXMLSourceType Numeric value
FileConnection 0
Variable 1
DirectInput 2

DestinationType and DiffGramDestinationType properties—Set by using values from the DTSXMLSaveResultTo enumeration.

Friendly name in DTSXMLSaveResultTo Numeric value
FileConnection 0
Variable 1

ValidationType property—Set by using values from the DTSXMLValidationType enumeration.

Friendly name in DTSXMLValidationType Numeric value
DTD 0
XSD 1

XPathOperation property—Set by using values from the DTSXMLXPathOperation enumeration.

Friendly name in DTSXMLXPathOperation Numeric Value
Evaluation 0
Values 1
NodeList 2

DiffOptions property—Set by using values from the DTSXMLDiffOptions enumeration. The options in this enumerator are not mutually exclusive. To use multiple options, provide a comma-separated list of the options to apply.

Friendly name in DTSXMLDiffOptions Numeric Value
None 0
IgnoreChildOrder 1
IgnoreComments 2
IgnorePI 4
IgnoreWhitespace 8
IgnoreNamespaces 16
IgnorePrefixes 32
IgnoreXmlDecl 64
IgnoreDtd 128

DiffAlgorithm property—Set by using values from the DTSXMLDiffAlgorithm enumeration.

Friendly name in DTSXMLDiffAlgorithm Numeric value
Auto 0
Fast 1
Precise 2

Maintenance Plan Tasks

Integration Services includes a set of tasks that perform SQL Server tasks for use in maintenance plans and Integration Services packages.

SQL Server does not support working with these tasks programmatically and programming reference documentation does not include API documentation of these tasks and their enumerators.

All Maintenance Tasks

All maintenance tasks use the following enumerations to set the specified properties.

DatabaseSelectionType property—Set by using values from the DatabaseSelection enumeration.

Friendly name in DatabaseSelection Numeric value
None 0
All 1
System 2
User 3
Specific 4

TableSelectionType property—Set by using values from the TableSelection enumeration.

Friendly name in TableSelection Numeric value
None 0
All 1
Specific 2

ObjectTypeSelection property—Set by using values from the ObjectType enumeration.

Friendly name in ObjectType Numeric value
Table 0
View 1
TableView 2

Back Up Database Task

DestinationCreationType property—Set by using values from the DestinationType enumeration.

Friendly name in DestinationType Numeric value
Auto 0
Manual 1

ExistingBackupsAction property—Set by using values from the ActionForExistingBackups enumeration.

Friendly name in ActionForExistingBackups Numeric value
Append 0
Overwrite 1

BackupAction property—Set by using values from the BackupTaskType enumeration. This property works with the BackupIsIncremental property to define the type of backup that the task performs.

Friendly name in BackupTaskType Numeric value
Database 0
Files 1
Log 2

BackupDevice property—Set by using values from the SQL Server Management Objects (SMO) DeviceType enumeration.

Friendly name in DeviceType Numeric value
LogicalDevice 0
Tape 1
File 2
Pipe 3
VirtualDevice 4

Maintenance Cleanup Task

FileTypeSelected property—Set by using values from the FileType enumeration.

Friendly name in FileType Numeric value
FileBackup 0
FileReport 1

OlderThanTimeUnitType property—Set by using values from the TimeUnitType enumeration.

Friendly Name in TimeUnitType Numeric Value
Day 0
Week 1
Month 2
Year 3

Update Statistics Task

UpdateType property—Set by using values from the SQL Server Management Objects (SMO) StatisticsTarget enumeration.

Friendly name in StatisticsTarget Numeric value
Column 1
Index 2
All 3

Common Properties

Packages, tasks, and the Foreach Loop, For Loop, and Sequence containers can use the following enumerations to set the specified properties.

ForceExecutionResult property—Set by using values from the DTSForcedExecResult enumeration.

Friendly name in DTSForcedExecResult Numeric value
None -1
Success 0
Failure 1
Completion 2

IsolationLevel property—Set by the .NET Framework IsolationLevel enumeration. For more information, see the .NET Framework Class Library in the MSDN Library.

LoggingMode property—Set by using values from the DTSLoggingMode enumeration.

Friendly name in DTSLoggingMode Numeric value
UseParentSetting 0
Enabled 1
Disabled 2

TransactionOption property—Set by using values from the DTSTransactionOption enumeration.

Friendly name in DTSTransactionOption Numeric value
NotSupported 0
Supported 1
Required 2

Add or Change a Property Expression

See Also

Use Property Expressions in Packages
Integration Services (SSIS) Packages
Integration Services Containers
Integration Services Tasks
Precedence Constraints