Documentation

Biml API Reference
AstTaskBaseNode.StaticUserDefinedItems Property
BimlStudio 2017

Specifies a collection of items that are common across all instances of the same type in the framework.
Assembly:
Biml (in Biml.dll)
Language Element:
AstTaskBaseNode is an abstract type, so it does not have a corresponding Biml language element.
.NET API Metadata
Types Containing This Property
  Parent Type Summary
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.
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.
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.
AstAzureHDInsightSubmitHiveJobTaskNode
The Azure HDInsight Hive Task submits a Hive job to Microsoft Azure HDInsight.
AstAzureHDInsightSubmitJobTaskNode
The Azure HDInstight Submit Job task task node is a common abstract base class for Azure HDInsight job submission tasks.
AstAzureHDInsightSubmitPigJobTaskNode
The Azure HDInsight Pig Task submits a Pig job to Microsoft Azure HDInsight.
AstBackupDatabaseTaskNode
The Back Up Database task can back up one or more SQL Server databases.
AstBulkInsertTaskNode
The Bulk Insert task is an efficient method of copying large amounts of data into a SQL Server table.
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.
AstCustomTaskNode
The AstCustomTaskNode type supports custom and third party SQL Server Integration Services tasks.
AstDataflowTaskNode
The AstEtlRootNode type corresponds directly to a SQL Server Integration Services dataflow task.
AstDataMiningQueryTaskNode
The Data Mining Query task runs prediction queries based on data mining models.
AstDataProfilingTaskNode
The Data Profiling task helps you to solve data problems by profiling specifed columns and column relationships in a data source.
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.
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.
AstFileSystemTaskNode
The File System Task performs commands against specified files and directories.
AstFtpTaskNode
The FTP task downloads and uploads data files and directories as part of an Integration Services workflow.
AstHistoryCleanupTaskNode
The History Cleanup task removes old, unneeded historical information from the database.
AstMaintenanceCleanupTaskNode
The Maintenance Cleanup task removed unneeded backup files or other maintenance-related files from the specified locations.
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.
AstNotifyOperatorTaskNode
The Notify Operator task sends notification messages via e-mail, pager, or net send to SQL Server Agent operators.
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.
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.
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.
AstTaskBaseNode
Abstract base class for defining Integration Services tasks.
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.
AstUpdateStatisticsTaskNode
The Update Statistics task updates SQL Server information about data in tables and indexes. SQL Server uses the information to improve query plans.
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.