Namespace Varigence.Languages.Biml.Task
This namespace houses information regarding the various SSIS tasks that are supported in Biml.
Classes
| 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. |
| AstAzureBlobDownloadTaskNode | The Azure Blob Download Task provides options to download files from Microsoft Azure Blob Storage. |
| AstAzureBlobTransferTaskNode | The Azure Blob Transfer task node is a common abstract base class for Azure Blob Upload and Download tasks. |
| AstAzureBlobUploadTaskNode | The Azure Blob Upload Task provides options to upload files to Microsoft Azure Blob Storage. |
| AstAzureDataLakeStoreFileSystemTaskNode | The Azure Data Lake Store File System task node corresponds directly to an Azure Data Lake Store File System Task. |
| AstAzureHDInsightCreateClusterTaskNode | The Azure HDInsight Create Cluster Task creates a new Microsoft Azure HDInsight cluster. |
| AstAzureHDInsightDeleteClusterTaskNode | The Azure HDInsight Delete Cluster Task deletes an existing Microsoft Azure HDInsight cluster. |
| AstAzureHDInsightHiveTaskNode | The Azure HDInsight Hive Task submits a Hive job to Microsoft Azure HDInsight. |
| AstAzureHDInsightJobBlobScriptResourceNode | AstAzureHDInsightJobBlobScriptResourceNode is used for referencing scripts stored in Azure blob storage that are to be sent to Azure HDInsight for job processing. |
| AstAzureHDInsightJobInlineScriptResourceNode | AstAzureHDInsightJobScriptResourceNode is used for authoring inline scripts to be sent to Azure HDInsight for job processing. |
| AstAzureHDInsightPigTaskNode | The Azure HDInsight Pig Task submits a Pig job to Microsoft Azure HDInsight. |
| AstAzureHDInsightSubmitJobTaskBaseNode | The Azure HDInstight Submit Job task task node is a common abstract base class for Azure HDInsight job submission tasks. |
| AstAzureSqlDataWarehouseUploadMappingNode | The Azure SQL Datawarehouse Upload task maps an columns from a text file to an Azure Sql Datawarehouse. |
| AstAzureSqlDataWarehouseUploadTaskNode | The Azure SQL Data Warehouse Upload task node corresponds directly to an Azure SQL Data Warehouse Upload 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. |
| AstCdcControlTaskNode | The CDC Control Task provides a variety of options for CDC control operations on a CDC-enabled SQL Server database. It corresponds directly to the CDC Control Task in SSIS 2012 and higher (http://msdn.microsoft.com/en-us/library/hh758674.aspx). |
| 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. |
| AstComponentResourceNode | The AstComponentResourceNode type is used for creating references to a SSIS dataflow component that has been modeled in the Biml project. |
| 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. |
| AstCustomTaskNode | The AstCustomTaskNode type supports custom and third party SQL Server Integration Services tasks. |
| 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. |
| AstExpressionTaskNode | The Expression Task will execute an SSIS expression. It is often used as a convenient host for variable assignments or to serve as a placeholder for control flow branching. |
| 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. |
| AstExternalProjectPackageResourceNode | The AstExternalProjectPackageResourceNode type is used for creating references to a package that has been created within the SSIS package project and which might not have been modeled within the Biml project. |
| 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. |
| AstFlatFileResourceNode | AstFlatFileResourceNode is used for creating references to flat file connections that have been modeled in the Biml project. |
| 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. |
| AstHadoopClusterInformationNode | AstHadoopClusterInformationNode objects correspond directly to the different Cluster Information configurations inside of Hadoop Connection Managers. |
| AstHadoopFileSystemTaskNode | The Hadoop File System task node corresponds directly to an Hadoop File System Task. |
| AstHadoopHiveTaskNode | The Hadoop Hive Task allows the user to run a Hive script on a Hadoop cluster. |
| AstHadoopJobTaskBaseNode | The Hadoop Job task node is a common abstract base class for Hadoop Pig and Hadoop Hive tasks. |
| AstHadoopPigTaskNode | The Azure Blob Upload Task provides options to upload files to Microsoft Azure Blob Storage. |
| AstHadoopScriptResourceNode | AstHadoopScriptResourceNode is used for specifying the path to Hadoop script files. |
| 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. |
| AstParameterNode | Defines a parameter for Data Integration Project or package. |
| 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. |
| AstSsisAnnotationNode | AstSsisAnnotationNode corresponds directly to a SQL Server Integration Services design surface text annotation. |
| AstSsisControlFlowPartResourceNode | The AstSsisControlFlowPartResourceNode type is used for creating references to a SSIS control flow part that has been modelled in the Biml project. |
| 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. |
| AstTaskBaseNode | Abstract base class for defining Integration Services tasks. |
| 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. |
| AstVariableBaseNode | Defines the base class for Variables and Parameters used in Data Integration projects |
| 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. |
Interfaces
| ISsisPackageFragment |