Varigence, Inc.

Expand Minimize
BIML API Reference
Varigence.Languages.Biml.Task Namespace
Classes
 NameSummary
AstAnalysisServicesExecuteDdlTaskNode
The Analysis Services Execute DDL task runs data definition language statements.
AstAnalysisServicesProcessingTaskNode
The Analysis Services Processing task processes Analysis Services objects such as cubes, dimensions, and mining models.
AstAutomaticDatabaseBackupDestinationNode
The AstAutomaticDatabaseBackupDestinationNode type corresponds directly to an automatic backup destination for the SQL Server Integration Services Database Backup task.
AstBackupDatabaseTaskNode
The Back Up Database task can back up one or more SQL Server databases.
AstBackupDestinationNode
AstBackupDestinationNode is an abstract type that serves as the base type for both the automatic and manual database backup destinations for the SQL Server Integration Services Database Backup task.
AstBulkInsertTaskNode
The Bulk Insert task is an efficient method of copying large amounts of data into a SQL Server table.
AstCandidateKeyProfileRequestNode
The AstCandidateKeyProfileRequestNode type corresponds directly to the candidate key data profile in the SQL Server Integration Services data profiling task, which will report which column(s) have unique values across rows and could consequently serve as keys.
AstCheckDatabaseIntegrityTaskNode
The Check Database Integrity task runs the DBCC CHECKDBT Transact- SQL command to verify the integrity of the database.
AstColumnLengthDistributionProfileRequestNode
The AstColumnLengthDistributionProfileRequestNode type corresponds directly to the column length distribution data profile in the SQL Server Integration Services data profiling task, which will report length statistics for columns with character types.
AstColumnNullRatioProfileRequestNode
The AstColumnNullRatioProfileRequestNode type corresponds directly to the column null ratio data profile in the SQL Server Integration Services data profiling task, which will report the frequency of null values in nullable columns.
AstColumnPatternProfileRequestNode
The AstColumnPatternProfileRequestNode type corresponds directly to the column pattern data profile in the SQL Server Integration Services data profiling task, which will compute a collection of patterns that describe the values in a character-based column.
AstColumnStatisticsProfileRequestNode
The AstColumnStatisticsProfileRequestNode type corresponds directly to the column statistics data profile in the SQL Server Integration Services data profiling task, which will report aggregation statistics for numeric and date/time columns.
AstColumnValueDistributionProfileRequestNode
The AstColumnValueDistributionRequestNode type corresponds directly to the column value distribution data profile in the SQL Server Integration Services data profiling task, which will report the number of occurences of each value for a given column.
AstComponentScriptProjectReferenceResourceNode
This resource type is used to reference an existing component script project.
AstComponentScriptProjectResourceNode
This resource type is used to create a new component script project.
AstConfigurationValueNode
The AstConfigurationValueNode type corresponds directly to an individual value setting within a SQL Server Integration Services package configuration.
AstContainerTaskBaseNode
AstContainerTaskBaseNode is the base type that is used for all SQL Server Integration Services task containers in Biml.
AstContainerTaskNode
AstContainerTaskNode corresponds directly to a SQL Server Integration Services sequence container task.
AstCubeProcessingConfigurationNode
The AstCubeProcessingConfigurationNode type describes cube processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstCustomExtensionContainerTaskNode
Custom tasks to run additional code or scripts during the creation of a Table, Dimension, or Fact.
AstDatabaseProcessingConfigurationNode
The AstDatabaseProcessingConfigurationNode type describes database processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstDataflowTaskNode
The AstEtlRootNode type corresponds directly to a SQL Server Integration Services dataflow task.
AstDataProfileRequestNode
AstDataProfileRequestNode is the base type for all data profiling types available in the SQL Server Integration Services data profiling task.
AstDataProfilingTaskNode
The Data Profiling task helps you to solve data problems by profiling specifed columns and column relationships in a data source.
AstDimensionProcessingConfigurationNode
The AstDimensionProcessingConfigurationNode type describes dimension processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstDirectResourceNode
The AstDirectResourceNode type provides the facility to directly input text data for use in the referencing Biml object.
AstEnvironmentVariableResourceNode
This resource references an environment variable on the computer.
AstExecutePackageSqlServerResourceNode
The AstExecutePackageSqlServerResourceNode type is used for creating references to a SQL Server Integration Services package stored in an existing SQL Server database that has not been modeled in the Biml project.
AstExecutePackageTaskNode
The Execute Package task allows packages to run other packages as part of a workflow.
AstExecuteProcessTaskNode
An Execute Process task can run business applications or batch files as part of a package workflow.
AstExecuteSqlParameterMappingTypeNode
The AstExecuteSqlParameterMappingTypeNode type provides the capability to map a named parameter onto a SQL Server Integration Services package variable value in an Execute SQL task.
AstExecuteSqlServerAgentJobTaskNode
The Execute SQL Server Agent Job task runs SQL Server Agent jobs specified in a maintenance plan.
AstExecuteSqlTaskNode
The Execute SQL task runs SQL statements during package execution.
AstExecuteTSqlStatementTaskNode
The Execute T-SQL Statement task can be used to add specified Transact-SQL statements to a maintenance plan.
AstExternalFileResourceNode
The AstExternalFileResourceNode type is used for creating references to a file path on the local file system that has not been modeled in the Biml project as a file connection.
AstFileNameFromVariableResourceNode
The AstFileNameFromVariableResourceNode type provides the facility to reference a SQL Server Integration Services package variable that contains a file name for use in the referencing Biml object.
AstFileResourceNode
AstFileResourceNode is used for creating references to file connections that have been modeled in the Biml project.
AstFileSystemTaskNode
The File System Task performs commands against specified files and directories.
AstForEachAdoLoopNode
The Foreach ADO Loop enumerates tables or table rows in data that is stored in a variable.
AstForEachAdoNetSchemaLoopNode
The Foreach ADO.NET Schema Loop enumerates specified information about the data source.
AstForEachAdoNetSchemaLoopRestrictionNode
AstForEachAdoNetSchemaLoopRestrictionNode is an abstract type that serves as the base type for all schema loop restriction types.
AstForEachAdoNetSchemaLoopRestrictionTextNode
The AstForEachAdoNetSchemaLoopRestrictionTextNode type corresponds directly to a text schema loop restriction in a SQL Server Integration Services ADO.NET Schema Loop Container task.
AstForEachAdoNetSchemaLoopRestrictionVariableNode
The AstForEachAdoNetSchemaLoopRestrictionVariableNode type corresponds directly to a variable schema loop restriction in a SQL Server Integration Services ADO.NET Schema Loop Container task.
AstForEachFileLoopNode
The Foreach File Loop enumerates files in a folder.
AstForEachFromVariableLoopNode
The Foreach From Variable Loop enumerates enumerable objects contained in a specified variable.
AstForEachItemLoopColumnNode
The AstForEachItemLoopColumnNode type corresponds directly to a column within a row defined for a Foreach Item Loop Container task in SQL Server Integration Services.
AstForEachItemLoopNode
The Foreach Item Loop enumerates items in collections.
AstForEachItemLoopRowNode
The AstForEachItemLoopRowNode type corresponds directly to a row defined for a Foreach Item Loop Container task in SQL Server Integration Services.
AstForEachLoopNode
AstForEachLoopNode corresponds directly to a SQL Server Integration Services foreach loop container task.
AstForEachNodeListLoopNode
The Foreach Nodelist Loop loops through all the nodes of an XML file that is the result of applying an Xpath expression to an XML file and enumerates and lists specified elements.
AstForEachSmoLoopNode
The Foreach SMO loop enumerates a SQL Server Management Objects (SMO) obect on a specified instance of SQL Server.
AstForLoopContainerTaskNode
AstForLoopContainerTaskNode corresponds directly to a SQL Server Integration Services for loop container task.
AstFtpTaskNode
The FTP task downloads and uploads data files and directories as part of an Integration Services workflow.
AstFunctionalDependencyProfileRequestNode
The AstFunctionalDependencyProfileRequestNode type corresponds directly to the functional dependency data profile in the SQL Server Integration Services data profiling task, which will report whether all column values in one column have a 1:1 or 1:Many correspondance with a specified related column.
AstHistoryCleanupTaskNode
The History Cleanup task removes old, unneeded historical information from the database.
AstIndirectFileResourceNode
This resource provides a reference to an environment variable that contains a file path for use by package configurations.
AstIndirectSqlServerResourceNode
This resource provides a reference to an environment variable that contains a SQL Server connection string for use by package configurations.
AstLogEventNode
The AstLogEventNode type corresponds directly to a log event in SQL Server Integration Services.
AstMaintenanceCleanupFolderTaskResourceNode
Specifies the folder and file extension information for the Maintenance Plan Cleanup Task.
AstMaintenanceCleanupTaskNode
The Maintenance Cleanup task removed unneeded backup files or other maintenance-related files from the specified locations.
AstManualDatabaseBackupDestinationNode
The AstManualDatabaseBackupDestinationNode type corresponds directly to an manual backup destination for the SQL Server Integration Services Database Backup task.
AstManualDatabaseBackupDestinationObjectNode
The AstManualDatabaseBackupDestinationObjectNode type corresponds directly to a database object that will be backed up as part of a manual backup destination in SQL Server Integration Services.
AstMeasureGroupProcessingConfigurationNode
The AstMeasureGroupProcessingConfigurationNode type describes measure group processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstMergeColumnNode
The AstMergeColumnNode type defines how an individual table column in a source table will be mapped to the target table when constructing a T-SQL merge statement in the merge task.
AstMergeTaskNode
The Merge task changes a target table based on the the results of a join with a source table.
AstMessageQueueTaskNode
The Message Queue task can send and receive messages between SSIS packages or to an application queue processed by a custom application. The messages can contain simple text, files, or variables and values.
AstMiningModelProcessingConfigurationNode
The AstMiningModelProcessingConfigurationNodetype describes mining model processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstMiningStructureProcessingConfigurationNode
The AstMiningStructureProcessingConfigurationNode type describes mining structure processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstNotifyOperatorTaskNode
The Notify Operator task sends notification messages via e-mail, pager, or net send to SQL Server Agent operators.
AstPackageConfigurationNode
The AstPackageConfigurationNode type corresponds directly to a package configuration that can apply setting information to a SQL Server Integration Services package.
AstPackageEmitTargetResourceNode
The AstPackageEmitTargetResourceNode type is used for creating references to any Biml object that has been modeled in the Biml project and can be compiled to produce a package.
AstPackageNode
The AstPackageNode type corresponds directly to a SQL Server Integration Services package.
AstPackageResourceNode
The AstPackageResourceNode type is used for creating references to a package that has been modeled in the Biml project.
AstParameterMappingTypeNode
AstParameterMappingTypeNode is an abstract type that serves as the base type for parameter mapping nodes in the Biml framework.
AstPartitionProcessingConfigurationNode
The AstPartitionProcessingConfigurationNode type describes partition processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstPersistFileResourceNode
The AstPersistFileResourceNode type provides the facility to directly input text data and then storing that text data in the specified file for use in the referencing Biml object.
AstProcessingConfigurationNode
AstProcessingConfigurationNode is an abstract type that serves as the base type for all processing configuration types used by the SQL Server Integration Services Analysis Services Processing task.
AstPropertyExpressionNode
The AstPropertyExpressionNode type provides the ability to map a SQL Server Integration Services expression value onto a property.
AstRebuildIndexTaskNode
The Rebuild Index task restores the free space on index pages.
AstReorganizeIndexTaskNode
The Reorganize Index task rearranges index pages to improve their search order.
AstRetryContainerTaskNode
AstRetryContainerTaskNode is an abstract type that creates a for loop container that will automatically re-run all child tasks as many times as is specified.
AstScriptTaskNode
The AstScriptTaskNode type corresponds directly to a SQL Server Integration Services script task.
AstSendMailTaskNode
The Send Mail task sends messages to specified recipients about tasks, events, and outcomes of the workflow.
AstShrinkDatabaseTaskNode
The Shrink Database Task, if possible, reduces the size of the specified databases.
AstStagingContainerTaskNode
AstStagingContainerTaskNode is an abstract type that creates one or more tables at the beginning of the container, executes child tasks, and then destroys the created tables at the end of the container.
AstStoredProcColumnNode
The AstStoredProcColumnNode is used to define the input and output columns that will be exposed by the parent Stored Procedure.
AstStoredProcNode
AstPackageNode is an abstract type that creates an ExecuteSQL task to create a stored procedure that can be referenced elsewhere in the Biml project.
AstStringVariableResourceNode
AstStringVariableResourceNode is used for creating references to variables that have been modeled in the Biml project. This is used with the AstMessageQueueTaskNode.
AstTableColumnResourceNode
This resource references a column from a table in the model.
AstTableFromVariableResourceNode
The AstTableFromVariableResourceNode type provides the facility to reference a SQL Server Integration Services package variable that contains a table name for use in the referencing Biml object.
AstTableHintParameterNode
The AstTableHintParameterNode type corresponds directly to a table or query hint in SQL Server.
AstTableResourceNode
The AstTableResourceNode type is used for creating references to a table that has been modeled in the Biml project.
AstTaskEventHandlerNode
The Task Event Handler performs responds to events raised by tasks in the package.
AstTaskflowInputPathNode
AstTaskflowInputPathNode is used to model input paths in a SQL Server Integration Services task control flow. Connections are made by referencing an appropriate output path.
AstTaskflowOutputPathNode
AstTaskflowOutputPathNode is used to model output paths in a SQL Server Integration Services task control flow. Connections are made by referencing an output path from an appropriate task precendence constraint.
AstTaskflowPrecedenceConstraintsNode
The AstTaskflowPrecedenceConstraintsNode type corresponds directly to a precedence constraint in a SQL Server Integration Services task control flow.
AstTaskNode
AstTaskNode is the base type that is used for all SQL Server Integration Services tasks in Biml.
AstTaskResourceNode
AstTaskResourceNode is an abstract type that serves as the base type for all complex resource reference types used in the Biml framework.
AstTaskScriptProjectReferenceResourceNode
This resource type is used to reference an existing task script project.
AstTaskScriptProjectResourceNode
This resource type is used to create a new task script project.
AstTransferDatabaseFileNode
The AstTransferDatabaseFileNode type describes a file that serves as the source or target of a SQL Server Integration Services Transfer Database task.
AstTransferDatabaseTaskNode
The Transfer Database task copies or moves a database between two instances of SQL Server.
AstTransferErrorMessagesTaskNode
The Transfer Error Messages task copies user-defined error messages from one instance of SQL Server to another.
AstTransferJobsTaskNode
The Transfer Jobs task copies SQL Server Agent jobs from one instance of SQL Server to another.
AstTransferLoginsTaskNode
The Transfer Logins task copies logins from one instance of SQL Server to another.
AstTransferMasterStoredProceduresTaskNode
The Transfer Master Stored Procedures Task copies user-define stored procedures frome one master database on to another master database on a different instance of SQL Server.
AstTransferSqlServerObjectsTaskNode
The Transfer SQL Server Objects task copies objects in a SQL Server database from on instance of SQL Server to another. The version of SQL Server being used determines what types of objects can be copied.
AstUnmanagedTableColumnResourceNode
This resource references a column and table that are not included in the model.
AstUnmanagedTableResourceNode
The AstUnmanagedTableResourceNode type is used for creating references to a table stored in an existing relational database that has not been modeled in the Biml project.
AstUpdateStatisticsTaskNode
The Update Statistics task updates SQL Server information about data in tables and indexes. SQL Server uses the information to improve query plans.
AstValueInclusionProfileRequestNode
The AstValueInclusionProfileRequestNode type corresponds directly to the value inclusion data profile in the SQL Server Integration Services data profiling task, which will report whether a proposed foreign key relationship between two tables would violate the foreign key constraint.
AstVariableNode
The AstVariableNode type corresponds directly to a task variable in SQL Server Integration Services.
AstVariableParameterMappingNode
The AstVariableParameterMappingNode type provides the capability to map a named parameter onto a SQL Server Integration Services package variable value.
AstVariableResourceNode
AstVariableResourceNode is used for creating references to variables that have been modeled in the Biml project.
AstVariablesResourceNode
AstVariablesResourceNode is used for creating references to collections of variables that have been modeled in the Biml project.
AstWebServiceParameterNode
The AstWebServiceParameterNode type provides the capability to map a named web service parameter onto a text or variable value with accompanying type information.
AstWebServiceTaskNode
The Web Service task executes a Web service method.
AstWmiDataReaderTaskNode
The WMI Data Reader task uses the Windows Management Instrumentation (WMI) Query Language to run queries about a computer system.
AstWmiEventWatcherTaskNode
The WMI Event Watcher task watches for and responds to Microsoft Windows Instrument (WMI) events.
AstXmlTaskNode
The XML Task retrieves XML data, performs specified operations, and saves the updated documents to specified files or variables.
Enumerations
 NameSummary
BackupDatabaseTaskBackupAction
The BackupDatabaseTaskBackupAction enumeration provides options for the type of backup that will be performed in a SQL Server Integration Services Backup Database task.
BackupDatabaseTaskBackupCompressionOption
The BackupDatabaseTaskBackupCompressionOption enumeration provides options for compession to be applied to the backup produced by a SQL Server Integration Services Backup Database task.
BackupDatabaseTaskBackupFilesExist
The BackupDatabaseTaskBackupFilesExist enumeration provides options for how existing backup files should be handled in a SQL Server Integration Services Backup Database task.
BackupDatabaseTaskDevice
The BackupDatabaseTaskDevice enumeration provides options for the type of physical device is used to store the backed up data in a SQL Server Integration Services Backup Database task.
BackupDatabaseTaskManualDestinationDeviceType
The BackupDatabaseTaskManualDestinationDeviceType provides options for the type of device that should be used as a manual backup destination.
BulkInsertTaskDataFileType
The BulkInsertTaskDataFileType enumeration provides options for the text format of the source file for a bulk insert operation.
ColumnValueDistributionProfileRequestValueDistributionOption
The ColumnValueDistributionProfileRequestValueDistributionOption enumeration provides options to specify whether the profile task should compute and report the distribution of all values or just those that occur frequently.
ConfigurationType
The ConfigurationType enumeration provides options for whether package configurations will be automatically created and where they will be stored.
ContainerConstraintMode
The ContainerConstraintMode enumeration provides values that indicate whether or not task precedence constraints are automatically created for a given container.
ContainerTransactionMode
The ContainerTransactionMode enumeration provides options for the transaction context of a given container.
CubeProcessingOption
The CubeProcessingOption enumeration lists the different Analysis Services processing operations are are available for target objects of Cube type.
DatabaseProcessingOption
The DatabaseProcessingOption enumeration lists the different Analysis Services processing operations are are available for target objects of Database type.
Delimiter
The Delimiter enumeration provides a list of common text delimiters for use by SQL Server Integration Services Bulk Insert Task and Flat File Formats. Additional delimiter characters can be specified separately as text.
DimensionProcessingOption
The DimensionProcessingOption enumeration lists the different Analysis Services processing operations are are available for target objects of Dimension type.
Direction
The Direction enumeration provides options for the role that a parameter plays in a query or stored procedure.
EventColumn
The EventColumn enumeration provides a list of system variables that can be logged along with the log event information. The selection of multiple variables is supported.
EventType
The EventType enumeration provides a collection of the event types that are recognized by SQL Server Integration Services.
ExecuteProcessTaskWindowStyle
The ExecuteProcessTaskWindowStyle enumeration provides options for the kind of window in which to run the process in a SQL Server Integration Services Execute Process task.
ExecuteSqlResultSet
The ExecuteSqlResultSet enumeration provides options for what type of data is returned by a command in an Execute SQL Task.
FileSystemTaskOperation
The FileSystemTaskOperation enumeration provides options for the type of file system operation to perform in a SQL Server Integration Services File System Task.
ForceExecutionResult
The ForceExecutionResult enumeration provides options for an execution result value that will result if the SQL Server Integration Services container executes.
ForEachAdoLoopEnumerationMode
The ForEachAdoLoopEnumerationMode enumeration provides options for which types of options should be enumerated byt the Foreach Ado Loop Container Task.
ForEachFileLoopFileNameQualifierType
The ForEachFileLoopFileNameQualifierType enumeration provides options for the format of the names of enumerated files in a SQL Server Integration Services Foreach File Loop Container task.
ForEachNodeListLoopEnumerationType
The ForEachNodeListLoopEnumerationType enumeration provides a list of enumeration types that can be returned by the XPath query in a Foreach Node List Loop Container Task.
ForEachNodeListLoopInnerElementType
If the initial XPath query returns an ElementCollection, the ForEachNodeListLoopInnerElementType enumeration provides a list of enumeration types that can be used to process the ElementCollection in a Foreach Node List Loop Container Task.
FtpTaskOperation
The FtpTaskOperation enumeration provides options for the type of FTP operation to perform in a SQL Server Integration Services FTP Task.
IncludeInDebugDump
The IncludeInDebugDump enumeration specifies the options available for including or excluding the value of a variable from debug dumps in SQL Server Integration Services.
IsolationLevel
The IsolationLevel enumeration provides options for the SQL Server isolation level to be used.
LoggingEventType
Commonly used Logging Events.
LoggingMode
The LoggingMode enumeration provides options for the enabling SQL Server Integration Services logging.
LogicalOperationType
The LogicalOperationType enumeration provides options for how the values of multiple precedence constraints on a task control flow input path should be combined to determine whether that task should execute in SQL Server Integration Services.
MaintenanceCleanupTaskFileType
The MaintenanceCleanupTaskFileType enumeration provides options for which files should be selected for cleanup.
MaintenancePlanDatabaseSelectionMode
The MaintenancePlanDatabaseSelectionMode enumeration provides options for which databases should be selected for maintenance.
MaintenancePlanObjectSelectionMode
The MaintenancePlanObjectSelectionMode enumeration provides options for which objects should be selected for maintenance.
MeasureGroupProcessingOption
The MeasureGroupProcessingOption enumeration lists the different Analysis Services processing operations are are available for target objects of Measure Group or Partition type.
MergeColumnUsage
The MergeColumnUsage enumeration provides options for how the specified column will be merged from the source table to the target table.
MessageQueueTaskEncryptionAlgorithm
The MessageQueueTaskEncryptionAlgorithm enumeration provides options for the encryption algorithm use to encrypt a private message in the SQL Server Integration Services Message Queue Task.
MessageQueueTaskStringCompareType
The MessageQueueTaskStringCompareType enumeration provides options for which comparison transformations will be used when filtering messages in the SQL Server Integration Services Message Queue Task.
MiningStructureProcessingOption
The MiningStructureProcessingOption enumeration lists the different Analysis Services processing operations are are available for target objects of Mining Structure type.
ProcessingOrder
The ProcessingOrder enumeration provides options for whether parallel or sequential processing is to be used during SQL Server Analysis Services object processing.
ProfileRequestThresholdSetting
The ProfileRequestThresholdSetting enumeration provides options for the behavior of threshold values for the various profiling tasks in SQL Server Integration Services.
ResourceType
The ResourceType enumeration provides a list of supported input types that are leveraged throughout the Biml model whenever the same type of model data can be referenced in multiple different ways.
ScriptProjectFileBuildAction
The ScriptProjectFileBuildAction enumeration provides options for how a file should be handled by the script project build process.
ScriptProjectLanguage
The ScriptProjectLanguage enumeration provides options for supported programming languages for script projects.
SendMailTaskPriority
The SendMailTaskPriority enumeration provides options for the priority of the e-mail message in a SQL Server Integration Services Send Mail task.
TableHintLimited
The TableHintLimited enumeration provides a list of predefined query and table hints that can be passed to the query optimizer. Additional hints can also be provided in string values.
TaskEvaluationOperationType
The TaskEvaluationOperationType enumeration provides options for determining the criteria for when a SQL Server Integration Services task precedence constraint is satisfied.
TaskEvaluationOperationValue
The TaskEvaluationOperationValue enumeration provides options for determining when the constraint component of a SQL Server Integration Services task precedence constraint is satisfied.
TimeUnit
The TimeUnit enumeration provides options for the time unit that will be applied to the cleanup threshold in a SQL Server Integration Services Maintenance Cleanup or History Cleanup task.
TransferDatabaseTaskAction
The TransferDatabaseTaskAction enumeration provides options for whether the database should be moved or copied during a SQL Server Integration Services Transfer Database task.
TransferLoginsTaskLoginsToTransfer
The TransferLoginsTaskLoginsToTransfer enumeration provides options for which logins should be transfered during a SQL Server Integration Services Transfer Logins task.
TransferSqlServerObjectTaskExistingDataOption
The TransferSqlServerObjectTaskExistingDataOption enumeration provides options for whether data copied from the source overwrites existing data in the destination database or is appended to the existing data in a SQL Server Integration Services Transfer SQL Server Objects task.
TransferTaskObjectExistsOption
The TransferTaskObjectExistsOption enumeration provides options for how the SQL Server Integration Services transfer task behaves if it encounters an existing object with the same name in the destination.
UpdateStatisticsTaskScanType
The UpdateStatisticsTaskScanType enumeration provides options for how many values must be examined before reporting statistics results.
UpdateStatisticsTaskUpdateType
The UpdateStatisticsTaskUpdateType enumeration provides options for which statistics will be recomputed for a given table.
WebServiceTaskParameterType
The WebServiceTaskParameterType enumeration provides a list of parameter type specifications for the Web Service Task.
WmiDataReaderTaskOutputType
The WmiDataReaderTaskOutputType enumeration provides options for the type of output that will be produced by the WMI Data Reader Task.
WmiDataReaderTaskOverwriteDestination
The WmiDataReaderTaskOverwriteDestination enumeration provides options for how the data reader should behave when the destination already exists.
WmiEventWatcherTaskActionAtEvent
The WmiEventWatcherTaskActionAtEvent enumeration provides options for how the WMI events should behave when new events are raised.
WmiEventWatcherTaskActionAtTimeout
The WmiEventWatcherTaskActionAtTimeout enumeration provides options for the behavior of the WMI Event Watcher Task after the timeout has been reached.
WmiEventWatcherTaskAfterEvent
The WmiEventWatcherTaskAfterEvent enumeration provides options for the behavior of the WMI Event Watcher Task after it successfully receives and processes a WMI event.
WritebackTableOption
The WritebackTableOption enumeration provides options for how writeback table creation will be handled for a given processing task.
XmlTaskDiffAlgorithm
The XmlTaskDiffAlgorithm enumeration provides a list of options for which Xml document differencing algorithm should be used by the Xml Task.
XmlTaskDiffOptions
The XmlTaskDiffOptions enumeration provides a list of options that determine the comparison behaviors of the Xml document differencing operation.
XmlTaskOperationType
The XmlTaskOperationType enumeration provides a list of options for which operation the Xml Task will perform.
XmlTaskValidationType
The XmlTaskValidationType enumeration provides a list of options for which method and validation document type will be used to perform the validation operation.
XmlTaskXPathOperation
The XmlTaskXPathOperation enumeration provides a list of options for what type of XPath query will be executed and which type of results will be returned.