Biml API Reference
AstScopeBoundaryNode.FriendlyTypeName Property
BimlStudio 2017

Gets the friendly name of the type of this node
Assembly:
Biml (in Biml.dll)
Language Element:
AstScopeBoundaryNode is an abstract type, so it does not have a corresponding Biml language element.
.NET API Metadata
Code Type:
Default Value:
Required:
False
Virtual:
False
Types Containing This Property
  Parent Type Summary
AstAdfActivityNode
AstAdfActivityNode is the abstract base type for all Azure Data Factory Activities.
AstAdfAzureBlobDatasetNode
AstAdfAzureBlobDatasetNode objects correspond directly to Azure Blob datasets in Azure Data Factory.
AstAdfAzureDataLakeDatasetNode
AstAdfAzureDataLakeDatasetNode objects correspond directly to Azure Data Lake Store datasets in Azure Data Factory.
AstAdfAzureDataLakeLinkedServiceNode
AstAdfAzureDataLakeLinkedServiceNode objects correspond directly to Azure Data Lake Store linked services in Azure Data Factory.
AstAdfAzureDocumentDbDatasetNode
AstAdfAzureDocumentDbDatasetNode objects correspond directly to Azure DocumentDB datasets in Azure Data Factory.
AstAdfAzureDocumentDbLinkedServiceNode
AstAdfAzureDocumentDbLinkedServiceNode objects correspond directly to Azure DocumentDB linked services in Azure Data Factory.
AstAdfAzureSqlDatabaseDatasetNode
AstAdfAzureSqlDatabaseDatasetNode objects correspond directly to Azure SQL Database datasets in Azure Data Factory.
AstAdfAzureSqlDatabaseLinkedServiceNode
AstAdfAzureSqlDatabaseLinkedServiceNode objects correspond directly to Azure SQL Database linked services in Azure Data Factory.
AstAdfAzureSqlDataWarehouseDatasetNode
AstAdfAzureSqlDataWarehouseDatasetNode objects correspond directly to Azure SQL Data Warehouse datasets in Azure Data Factory.
AstAdfAzureSqlDataWarehouseLinkedServiceNode
AstAdfAzureSqlDataWarehouseLinkedServiceNode objects correspond directly to Azure SQL Data Warehouse linked services in Azure Data Factory.
AstAdfAzureStorageLinkedServiceNode
AstAdfAzureStorageLinkedServiceNode objects correspond directly to Azure Storage linked services in Azure Data Factory.
AstAdfAzureTableDatasetNode
AstAdfAzureTableDatasetNode objects correspond directly to Azure Table datasets in Azure Data Factory.
AstAdfCopyActivityNode
AstAdfCopyActivityNode objects correspond directly the Copy activity in Azure Data Factory, which is referred to by the type 'Copy'.
AstAdfDataFactoryNode
AstAdfDataFactoryNode objects correspond directly to Azure Data Factories.
AstAdfDatasetNode
AstAdfDatasetNode is the abstract base type for all Azure Data Factory Datasets.
AstAdfDb2DatasetNode
AstAdfDb2DatasetNode objects correspond directly to on-premises or IaaS DB2 datasets in Azure Data Factory.
AstAdfDb2LinkedServiceNode
AstAdfDb2LinkedServiceNode objects correspond directly to on-premises or IaaS DB2 linked services in Azure Data Factory.
AstAdfDotNetNode
AstAdfDotNetActivityNode objects correspond directly the custom activity in Azure Data Factory, which is referred to by the type 'DotNetActivity'.
AstAdfFileSystemDatasetNode
AstAdfFileSystemDatasetNode objects correspond directly to on-premises or IaaS File System datasets in Azure Data Factory.
AstAdfFileSystemLinkedServiceNode
AstAdfFileSystemLinkedServiceNode objects correspond directly to on-premises or IaaS File System linked services in Azure Data Factory.
AstAdfGatewayNode
AstAdfHadoopStreamingActivityNode
AstAdfHadoopStreamingActivityNode objects correspond directly the Hadoop Streaming activity in Azure Data Factory, which is referred to by the type 'HDInsightStreamingActivity'.
AstAdfHdfsDatasetNode
AstAdfHdfsDatasetNode objects correspond directly to on-premises or IaaS Hadoop Distributed File System (HDFS) datasets in Azure Data Factory.
AstAdfHdfsLinkedServiceNode
AstAdfHdfsLinkedServiceNode objects correspond directly to on-premises or IaaS Hadoop Distributed File System (HDFS) linked services in Azure Data Factory.
AstAdfHiveActivityNode
AstAdfHiveActivityNode objects correspond directly the Hadoop Hive activity in Azure Data Factory, which is referred to by the type 'HDInsightHive'.
AstAdfLinkedServiceNode
AstAdfLinkedServiceNode is the abstract base type for all Azure Data Factory Linked Services.
AstAdfMachineLearningBatchActivityNode
AstAdfMachineLearningBatchActivityNode objects correspond directly the Azure Machine Learning web service Batch Execution activity in Azure Data Factory, which is referred to by the type 'AzureMLBatchExecution'.
AstAdfMapReduceActivityNode
AstAdfMapReduceActivityNode objects correspond directly the Hadoop MapReduce activity in Azure Data Factory, which is referred to by the type 'HDInsightMapReduce'.
AstAdfMySqlDatasetNode
AstAdfMySqlDatasetNode objects correspond directly to on-premises or IaaS MySQL datasets in Azure Data Factory.
AstAdfMySqlLinkedServiceNode
AstAdfMySqlLinkedServiceNode objects correspond directly to on-premises or IaaS MySQL linked services in Azure Data Factory.
AstAdfODataDatasetNode
AstAdfODataDatasetNode objects correspond directly to OData datasets in Azure Data Factory.
AstAdfODataLinkedServiceNode
AstAdfODataLinkedServiceNode objects correspond directly to OData linked services in Azure Data Factory.
AstAdfOdbcDatasetNode
AstAdfOdbcDatasetNode objects correspond directly to on-premises or IaaS ODBC datasets in Azure Data Factory.
AstAdfOdbcLinkedServiceNode
AstAdfOdbcLinkedServiceNode objects correspond directly to on-premises or IaaS ODBC linked services in Azure Data Factory.
AstAdfOnPremisesDatabaseLinkedServiceBaseNode
AstAdfOracleDatasetNode
AstAdfOracleDatasetNode objects correspond directly to on-premises or IaaS Oracle datasets in Azure Data Factory.
AstAdfOracleLinkedServiceNode
AstAdfOracleLinkedServiceNode objects correspond directly to on-premises or IaaS Oracle linked services in Azure Data Factory.
AstAdfPigActivityNode
AstAdfPigActivityNode objects correspond directly the Hadoop Pig activity in Azure Data Factory, which is referred to by the type 'HDInsightPig'.
AstAdfPipelineNode
AstAdfPipelineNode objects correspond directly to pipelines in Azure Data Factory.
AstAdfPostgreSqlDatasetNode
AstAdfPostgreSqlDatasetNode objects correspond directly to on-premises or IaaS PostgreSQL datasets in Azure Data Factory.
AstAdfPostgreSqlLinkedServiceNode
AstAdfPostgreSqlLinkedServiceNode objects correspond directly to on-premises or IaaS PostgreSQL linked services in Azure Data Factory.
AstAdfRootObjectNode
AstAdfRootObjectNode is the abstract base type for all Azure Data Factory assets that can be defined at the root level of a Biml file.
AstAdfSimpleLinkedServiceBaseNode
AstAdfSimpleLinkedServiceBaseNode is the abstract base class for all Azure Data Factory linked services that are configured primarily with a connection string property.
AstAdfSqlServerDatasetNode
AstAdfSqlServerDatasetNode objects correspond directly to on-premises or IaaS SQL Server datasets in Azure Data Factory.
AstAdfSqlServerLinkedServiceNode
AstAdfSqlServerLinkedServiceNode objects correspond directly to on-premises or IaaS SQL Server linked services in Azure Data Factory.
AstAdfSqlServerStoredProcedureActivityNode
AstAdfSqlServerStoredProcedureActivityNode objects correspond directly the SQL Server Stored Procedure activity in Azure Data Factory, which is referred to by the type 'SqlServerStoredProcedure'.
AstAdfSybaseDatasetNode
AstAdfSybaseDatasetNode objects correspond directly to on-premises or IaaS Sybase datasets in Azure Data Factory.
AstAdfSybaseLinkedServiceNode
AstAdfSybaseLinkedServiceNode objects correspond directly to on-premises or IaaS Sybase linked services in Azure Data Factory.
AstAdfTeradataDatasetNode
AstAdfTeradataDatasetNode objects correspond directly to on-premises or IaaS Teradata datasets in Azure Data Factory.
AstAdfTeradataLinkedServiceNode
AstAdfTeradataLinkedServiceNode objects correspond directly to on-premises or IaaS Teradata linked services in Azure Data Factory.
AstAdfWebLinkedServiceNode
AstAdfWebTableLinkedServiceNode objects correspond directly to Web Table linked services in Azure Data Factory.
AstAdfWebTableDatasetNode
AstAdfWebTableDatasetNode objects correspond directly to Web Table datasets in Azure Data Factory.
AstAdoNetDestinationNode
The ADO.NET destination loads data into a ADO.NET-compliant database that uses a database table or view.
AstAdoNetSourceNode
The ADO.NET Source reads data from a ADO.NET-compliant database that uses a database table or view.
AstAggregateNode
The Aggregate transformation aggregates and groups values in a data set.
AstAnalysisMetadataBaseNode
The AstAnalysisMetadataBaseNode class serves as an abstract base class for all SQL Server Analysis Services (SSAS) metadata that can be attached to a table object. these include both multidimensional and tabular metadata.
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.
AstAuditNode
The Audit transformation performs specified audits on the incoming dataflow rows and adds audit information to the outgoing dataflow rows.
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.
AstBalancedDataDistributorNode
The Balanced Data Distributor Transformation creates splits its input rows into equal proportions and distributes it to its output paths. This is normally used to better take advantage of the parallelism features of your target server or to distribute rows across server shards. You will need to install this component on your server as it is published by Microsoft as a download. Please see http://blogs.msdn.com/b/sqlperf/archive/2011/05/25/the-balanced-data-distributor-for-ssis.aspx for more information.
AstBulkInsertTaskNode
The Bulk Insert task is an efficient method of copying large amounts of data into a SQL Server table.
AstCacheTransformNode
The Cache Transform transformation writes data from a connnected data source to a specified cache. This data can later be used by the lookup transformation. Using a cache enables multiple lookups to share the same cache rather than separately loading duplicate data.
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).
AstCdcSourceNode
The CDC Source reads data from a a CDC-enabled SQL Server table and outputs rows that reflect the changes that have taken place in the specified processing range.
AstCdcSplitterNode
The CDC Splitter component partitions rows from a CDC Source component based on its status as an inserted, updated, or deleted row.
AstCharacterMapNode
The Character Map transformation converts character data by applying string transformation operations.
AstCheckDatabaseIntegrityTaskNode
The Check Database Integrity task runs the DBCC CHECKDBT Transact- SQL command to verify the integrity of the database.
AstComponentScriptProjectInputBufferNode
The AstComponentScriptProjectInputBufferNode corresponds directly to input buffer column mappings within a SQL Server Integration Services dataflow Script Component.
AstComponentScriptProjectNode
The AstComponentScriptProjectNode corresponds directly to the project embedded within a SQL Server Integration Services dataflow Script Component.
AstComponentScriptProjectOutputBufferNode
The AstComponentScriptProjectOutputBufferNode corresponds directly to output buffer column mappings within a SQL Server Integration Services dataflow Script Component.
AstConditionalSplitNode
The Conditional Split transformation routes source data rows to different output paths by evaluating expressions.
AstContactVerifyNode
The Melissa Data Contact Verify custom component is used to detect suspicious values, standardize, normalize, verify, correct, or supplement various properties of contact information, including names, addresses, geocoding, phone numbers, and email addresses. It uses a local or remote database that is regularly updated with the latest data from the U.S. and Canada. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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.
AstCopyColumnNode
The Copy Column transformation copies input columns and uses them to create new columns in the transformation output.
AstCubeDimensionNode
Cube Dimension objects correspond directly to cube dimensions as defined in SQL Server Analysis Services (SSAS). They have all of the same capabilities and limitations.
AstCubeMeasureGroupNode
A measure group associates dimensions with measures and groups measures to optimize processing. This collection is used to define a cube measure group, which references a fact table. Each fact table might be referenced by multiple cube measure groups in cases where a single fact table might be used in multiple ways. For example, a fact table that tracks customer activity might be used both in a sales and an account measure group for a sales-tracking cube.
AstCubeNode
Cube objects correspond directly to SQL Server Analysis Services (SSAS) cubes, which offer a multidimensional data storage and query mechanism.
AstCubeProjectNode
This node defines an SSAS project (DWProj file), with associated cubes and dimensions. This object is used primarily when multiple cubes are defined within the same Biml solution and those cubes must be emitted into separate projects.
AstCustomComponentNode
The Custom Component transformation represents a custom component in SSIS.
AstCustomComponentSourceNode
Defines a custom source component.
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.
AstDatabaseNode
Database objects correspond directly to SQL Server databases, which are logical containers for tables, stored procedures, views, schemas, and other database objects. Note that databases are currently not used to genereate SQL code and can only be used to enable tables and schemas with the same unqualified name to be generated by the BIML framework.
AstDataConversionNode
The Data Conversion transformation converts the value in a column from its present type to a specified type and copies it to a new column.
AstDataflowTaskNode
The AstEtlRootNode type corresponds directly to a SQL Server Integration Services dataflow task.
AstDataMiningModelTrainingNode
The Data Mining Model Training destination is used to train data models in an Analysis Services cube.
AstDataMiningQueryNode
The Data Mining Query transformation runs a Data Mining Extensions (DMX) querie against a specified data mining model.
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.
AstDataReaderDestinationNode
The DataReader destination loads dataflow rows into an ADO.NET data reader for consumption by other applications or components.
AstDerivedColumnListNode
The Derived Column transformation applies expressions to input columns to generate new column values.
AstDestinationTransformationNode
AstDestinationTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml that are destinations (i.e. no non-error output paths).
AstDimensionMetadataNode
Dimension metadata objects include all of the information necessary to use the parent table as the basis to create a Dimension in SQL Server Analysis Services (SSAS).
AstDimensionNode
Dimension objects include all of the capabilities of regular tables and additionally correspond directly to a Dimension in SQL Server Analysis Services (SSAS).
AstDimensionProcessingNode
The Dimension Processing destination loads and processes an SQL Server Analysis Services dimension.
AstDqsCleansingNode
The DQS Cleansing transformation replaces values of incoming data flow columns with corresponding values that have been corrected using rules specified in a Microsoft SQL Server Data Quality Services (DQS) instance.
AstExcelDestinationNode
The Excel destination loads data into Microsoft Excel workbooks.
AstExcelSourceNode
The Excel source extracts data from Microsoft Excel workbooks.
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.
AstExportColumnNode
The Export Column transformation exports column values from rows in a data set to files.
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.
AstFactNode
Fact table objects include all of the capabilities of regular tables and additionally correspond directly to a Measure Group in SQL Server Analysis Services (SSAS).
AstFileSystemTaskNode
The File System Task performs commands against specified files and directories.
AstFlatFileDestinationNode
The Flat File destination writes data to a flat text file in a format specified by a FlatFileFormat definition.
AstFlatFileSourceNode
The Flat File Source reads data from a flat text file in a format specified by a FlatFileFormat definition.
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.
AstFuzzyGroupingNode
The Fuzzy Grouping transformation groups data set rows that contain similar values.
AstFuzzyLookupNode
The Fuzzy Lookup transformation looks up values in a reference data set by using fuzzy matching. That is, matches can be close rather than exact.
AstFuzzyMatchNode
The Melissa Data Fuzzy Match custom component provides a robust, highly configurable collection of options to perform fuzzy matching on any selected input data fields. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstGlobalVerifyNode
The Melissa Data Global Verify custom component is used to verify, correct, and supplement various properties of contact information across more than 240 countries, ensuring that address records are correct and complete. It uses a local or remote database that is regularly updated with the latest international data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstHistoryCleanupTaskNode
The History Cleanup task removes old, unneeded historical information from the database.
AstImportColumnNode
The Import Column transformation loads data from files into columns in a data flow.
AstIsNullPatcherNode
The Is Null Patcher will rewrite the specified columns to a default value if they have a null value.
AstLookupNode
The Lookup transformation combines data in input columns with data in columns in a reference data set. It is the data flow equivalent of a SQL join.
AstMaintenanceCleanupTaskNode
The Maintenance Cleanup task removed unneeded backup files or other maintenance-related files from the specified locations.
AstMatchUpNode
The Melissa Data Match Up custom component is used to identify duplicate contact records. Even when contact properties are not exact matches, the component uses fuzzy matching and a variety of scoring algorithms to identify matches. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstMeasureGroupMetadataNode
Measure group metadata objects include all of the information necessary to use the parent table as the basis to create a Measure Group in SQL Server Analysis Services (SSAS).
AstMergeJoinNode
The Merge Join transformation merges data from two data sets by using a join.
AstMergeNode
The Merge transformation combines date from two sorted data sets into a single data set.
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.
AstMetadataBaseNode
This is the common abstract base class for all global Biml project metadata items.
AstMetadataInstanceNode
Metadata instance objects include all of the metadata specifications for a given metadata model. Note that there may be many metadata instance objects for each metadata model. The metadata model specifies the structure and rules for a collection of metadata. The metadata instance specifies the actual metadata within that model.
AstMetadataItemEntityDataNode
Metadata items specify all metadata properties, relationships, and column mappings for a given item or row within a a metadata model entity. Using a relational database analogy, if the metadata model entities were tables, metadata instance items would be the rows that populate those tables.
AstMetadataItemEntityNode
Metadata item entity objects are used to store actual metadata information associated with a referenced metadata model entity.
AstMetadataModelEntityNode
Metadata model entities specify all of the information needed to track an individual entity within the model. Using a relational database analogy, each entity would correspond to a table, while relationships correspond to foreign keys and properties and mappings correspond to table columns.
AstMetadataModelEntityRelationshipNode
Entity relationships define the relationships that exist between the parent entity and other entities within the model. Using a relational database analogy, if the metadata model entities were tables, relationships would be foreign keys that relate those tables.
AstMetadataModelMappingTypeNode
This is the abstract base class for all metadata model colmn mapping specifications.
AstMetadataModelNode
A metadata model defines all configuration necessary for an end-user to specify and validate metadata that will be used by downstream BimlScripts to automatically generate assets.
AstMetadataModelPropertyNode
Properties add configuration values to various objects within the metadata model.
AstMetadataModelPropertyPermittedValueSetNode
Permitted value set objects provide a collection of permitted values to be used to constrain the allowable inputs for a metadata model property.
AstMetadataModelValidatorNode
This is the class that is used as the basis for all validator rules that can be specified on a metadata model or any of its components.
AstMiningModelNode
The mining model receives data from the mining structure, applies a mining model algorithm, and routes the data to specified locations. Mining models can be queried directly or participate in downstream data processing.
AstMiningStructureNode
This value displays the current cube state with respect to processing.
AstMulticastNode
The Multicast Transformation creates multiple copies of source data and distributes them to multiple output paths.
AstMultipleColumnTableReferenceNode
Multiple-column table references are used to create a local column with a relationship to a multiple-column key of a regular table. Multiple-column table references can be used with foreign keys having any number of columns. Use table reference columns for a version of table references that is optimized for single column keys.
AstMultipleHashNode
The Multiple Hash custom component is used to produce hash values for a selection of input columns using a choice of hashing algorithms. It is capable of producing multiple hashed output columns with a single instance of the component. You will need to install this component on your server as it is published on CodePlex as a community project. Please see http://ssismhash.codeplex.com for more information.
AstMultipleInTransformationNode
AstMultipleInTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml that have a dynamic number of input paths.
AstNotifyOperatorTaskNode
The Notify Operator task sends notification messages via e-mail, pager, or net send to SQL Server Agent operators.
AstOdbcDestinationNode
The ODBC Destination loads data into an ODBC-compliant database that uses a database table, a view, or an SQL command.
AstOdbcSourceNode
The ODBC Source reads a data source using one of the ODBC adapters available on the host system.
AstOfflineSchemaColumnNode
The AstOfflineSchemaColumnNode class defines the type metadata information for an individual column within an offline schema.
AstOfflineSchemaItemNode
The AstOfflineSchemaItemNode stores all information necessary to build a package that targets a specific table or query without having to inspect the schema information for the live table or query at build time. It is essentially a cache of column type information for a table or query result set.
AstOfflineSchemaNode
The AstOfflineSchemaNode stores all information necessary to build a package that targets a specific data source without having to connect to the data source at build time. It is essentially a cache of offline schema items, each containing column type information for a table or query result set.
AstOleDbCommandNode
The OLE DB command transformation executes SQL statements to access and transform external data.
AstOleDbDestinationNode
The OLE DB destination loads data into an OLE DB-compliant database that uses a database table, a view, or an SQL command.
AstOleDbSourceNode
The OleDbSource reads a data source using one of the OLEDB adapters available on the host system.
AstOracleDestinationNode
The Oracle Destination loads data into an Oracle database that uses a database table, a view, or an SQL command. This is done specifically using the Attunity Oracle Connector.
AstOracleSourceNode
The Oracle Source reads an Oracle data source using the Attunity Oracle Connector.
AstPackageNode
The AstPackageNode type corresponds directly to a SQL Server Integration Services package.
AstPackageProjectNode
This node defines an SSIS project, with associated project parameters and packages. This object is used primarily on projects targeted to the SSIS 2012 platform.
AstPartitionProcessingDestinationNode
The Partition Processing destination loads and processes a SQL Server Analysis Services partition.
AstPercentageSamplingNode
The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input.
AstPersonatorNode
The Melissa Data Personator custom component is used to verify, correct, and supplement various properties of contact information, ensuring that records are correct and complete. It uses a local or remote database that is regularly updated with the latest international data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstPivotNode
The Pivot transformation creates a less normalized representation of a data set by taking multiple rows and converting them into a single with multiple columns.
AstProjectBaseNode
AstProjectBaseNode is an abstract type that serves as the base type for all project files (such as DTProj and DWProj) that can be defined within a Biml project.
AstRawFileDestinationNode
The Raw File destination loads dataflow rows into a raw data file using a file format that is native to this component. This destination and the accompanying source component is intended to improve performance by leveraging the native file format.
AstRawFileSourceNode
The Raw File Source reads dataflow rows from a raw data file using a file format that is native to this component. This source and the accompanying destination component is intended to improve performance by leveraging the native file format.
AstRebuildIndexTaskNode
The Rebuild Index task restores the free space on index pages.
AstRecordSetDestinationNode
The Recordset Destination component creates an in-memory ADO recordset that is stored in a variable.
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.
AstRowCountNode
The Row Count transformation counts rows as the data flows through it and stores the total row count in a variable after the last row is counted.
AstRowSamplingNode
The Row Sampling transformation generates a sample data set by randomly selecting a specified number of data flow rows from the input.
AstSchemaNode
Schema objects correspond directly to SQL Server schemas, which are logical containers for tables, stored procedures, views, and other database objects.
AstScopeBoundaryNode
AstScopeBoundaryNode is the base type that is used for all classes that define a scope in Biml. When an object is a scope boundary, its name will appear as a component of the full scope name of any descendent objects.
AstScriptComponentDestinationNode
The Script Component Destination type corresponds directly to a SQL Server Integration Services script component with an input buffer.
AstScriptComponentSourceNode
The Script Component Source type corresponds directly to a SQL Server Integration Services script component with output buffers.
AstScriptComponentTransformationNode
The Script Component Transformation type corresponds directly to a SQL Server Integration Services script component with both an input buffer and output buffers.
AstScriptProjectNode
The AstScriptProjectNode is the base class used for all SQL Server Integration Services script project types.
AstScriptTaskNode
The AstScriptTaskNode type corresponds directly to a SQL Server Integration Services script task.
AstSecurableNode
AstSecurableNode is the base type that is used for all classes that can accept permissions in Biml.
AstSendMailTaskNode
The Send Mail task sends messages to specified recipients about tasks, events, and outcomes of the workflow.
AstServerNode
This node represents a server. For example, it can represent a SQL Server instance.
AstShrinkDatabaseTaskNode
The Shrink Database Task, if possible, reduces the size of the specified databases.
AstSingleInTransformationNode
AstSingleInTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml that have a single input path.
AstSlowlyChangingDimensionNode
The Slowly Changing Dimension transformation checks for dimension attribute changes in incoming data, determines how related records are updated, and specifies how the updated records are inserted into data warehouse dimension tables.
AstSmartMoverNode
The Melissa Data Smart Mover custom component is used to identify contacts who have reloacted and automatically update their contact information. It uses a local or remote database that is regularly updated with the latest U.S. data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstSortNode
The Sort transformation sorts input data in the specified order and then copies the sorted data to an output file.
AstSourceTransformationNode
AstSourceTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml that are sources (i.e. no input paths).
AstSqlServerCompactDestinationNode
The SQL Server Compact destination writes data to SQL Server Compact databases.
AstSqlServerDestinationNode
The SQL Server destination bulk loads data into SQL Server tables and views.
AstSqlServerPdwDestinationNode
The SQL Server PDW destination loads data into a Microsoft SQL Server Parallel Data Warehouse (PDW) appliance. In later versions, PDW is rebranded as the Microsoft Analytics Platform System.
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.
AstTableCloneNode
TableClone enables you to create a copy of an existing table, allowing you to add your own additional columns, indexes, and keys in order to support staging mechanisms, temp-tables, etc.
AstTableColumnBaseNode
AstTableColumnBaseNode is the base type that is used for all table column types in Biml.
AstTableColumnNode
Columns represent regular SQL Server table columns. They have no special properties or capabilities beyond regular SQL Server columns.
AstTableColumnTableReferenceBaseNode
This is an abstract base node for all Table and Dimension Reference column types.
AstTableColumnTableReferenceNode
Table reference columns are used to create a local column with a relationship to a key column of a table, dimension, or fact table. Table reference columns can be used only with single column foreign keys, and the column properties will be directly inferred from the key of the foreign table. Use the multiple column table reference for keys with multiple columns.
AstTableHashedKeyColumnNode
Hashed Key Columns automatically create a computed column that is an SHA-1 hash of all of the columns included in the referenced constraint. This column type is useful for creating a single column key value that mirrors a chosen multi-column key.
AstTableNode
Table objects correspond directly to regular tables in the SQL Server product. They support all of the same features and present all of the same limitations.
AstTabularColumnNode
Tabular column objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model table columns, which offer aggregation and other options for use in analytics.
AstTabularHierarchyNode
Tabular hierarchy objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model hierarchies, which organize table columns and measures into tree structures for use in analytics.
AstTabularLevelNode
Tabular level objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model hierarchy levels , which constitute tabular hierarchies.
AstTabularMeasureNode
Tabular measure objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model measures, which allow expressions with custom logic to be provided for use in analytics.
AstTabularMetadataNode
Tabular metadata objects include all of the information necessary to use the parent table as the basis to create a table within a Tabular model in SQL Server Analysis Services (SSAS).
AstTabularModelNode
Tabular model objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Models, which offer a tabular data storage and query mechanism.
AstTabularPartitionNode
Tabular partition objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model table partitions, which allow the data stored in tabular tables to be split among multiple chunks or partitions for better performance and management capabilities.
AstTabularPerspectiveNode
Tabular perspective objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model perspectives, specify permissions for models.
AstTabularProjectNode
This node defines an SSAS project (SMProj file), with associated tabular models (also known as BI Model or BIM). This object is used primarily when multiple tabular models are defined within the same Biml solution and those tabular models must be emitted into separate projects.
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.
AstTaskScriptProjectNode
The AstTaskScriptProjectNode corresponds directly to the project embedded within a SQL Server Integration Services Script Task.
AstTeradataDestinationNode
The Teradata Destination loads data into a Teradata database that uses a database table, a view, or an SQL command. This is done specifically using the Attunity Teradata Connector.
AstTeradataSourceNode
The Teradata Source reads a Teradata data source using the Attunity Teradata Connector.
AstTermExtractionNode
The Term Extraction transformation extracts terms from input text columns and directs the terms to output text columns.
AstTermLookupNode
The Term Lookup transformation extracts terms from input text, places the terms in an input column, and compares these terms to terms in a reference table.
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.
AstTransformationNode
AstTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml.
AstUnionAllNode
The Union All transformation combines rows from multiple input paths into a single output path, using column mappings where necessary.
AstUnpivotNode
The Unpivot transformation creates a more normalized representation of a data set by taking values from multiple columns in the same row and breaking it up into multiple rows with a label column and a column containing the original data value.
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.
AstXmlSourceNode
The XML source reads an XML data file, optionally validating it, and creates a data flow output rows with the resulting data.
AstXmlTaskNode
The XML Task retrieves XML data, performs specified operations, and saves the updated documents to specified files or variables.