Documentation

Biml API Reference
AstTaskNode.SystemVariables Property
BimlStudio 2017

Gets a collection of all variables defined in this task that have been provided by SSIS as system variables
Assembly:
Biml (in Biml.dll)
Language Element:
AstTaskNode 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.
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.
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.
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.
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.
AstForEachFileLoopNode
The Foreach File Loop enumerates files in a folder.
AstForEachFromVariableLoopNode
The Foreach From Variable Loop enumerates enumerable objects contained in a specified variable.
AstForEachItemLoopNode
The Foreach Item Loop enumerates items in collections.
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.
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.
AstPackageNode
The AstPackageNode type corresponds directly to a SQL Server Integration Services package.
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.
AstSsisControlFlowPartNode
The Control Flow Part enables SSIS developers to create reusable fragments of SSIS control flows. For Biml developers, this can be a useful tool for collaborating with team members that do not use Biml. Specifically, Biml can be used to autogenerate control flow parts that are consumed by manually developed SSIS packages.
AstSsisControlFlowPartReferenceTaskNode
AstControlFlowPartReferenceTaskNode enables the referencing and import of either an externally defined SSIS control flow part by its file path or a Biml-defined SSIS control flow part by reference.
AstSsisPackagePartBaseNode
The Package Part Base type provides an abstract base type for all SSIS package parts.
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.
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.
AstTaskEventHandlerNode
The Task Event Handler performs responds to events raised by tasks in the package.
AstTaskNode
AstTaskNode is the base type that is used for all SQL Server Integration Services tasks in Biml.
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.