Biml API Reference
AstNode.IsAstNodeReadOnly Property
BimlStudio 2017

Gets a value indicating whether this node is currently in a read-only state
Assembly:
Biml (in Biml.dll)
Language Element:
AstNode is an abstract type, so it does not have a corresponding Biml language element.
.NET API Metadata
Code Type:
Default Value:
False
Required:
False
Virtual:
False
Types Containing This Property
  Parent Type Summary
AstActionNode
Action objects represent actions that are stored on the Analysis Services cube and executed by client applications such as Microsoft Excel.
AstActionReferenceNode
The AstActionReferenceNode type is a wrapper for a direct reference to an action for use in a cube perspective.
AstAdfActivityNode
AstAdfActivityNode is the abstract base type for all Azure Data Factory Activities.
AstAdfActivityPolicyNode
AstAdfActivityPolicyNode objects correspond directly to the policy specifications for Azure Data Factory activities.
AstAdfActivityScheduleNode
AstAdfActivityScheduleNode objects correspond directly to scheduler specifications for activities in Azure Data Factory.
AstAdfAvroFormatNode
AstAdfAvroFormatNode objects correspond directly to Azure Data Factory AvroFormat objects.
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.
AstAdfDatasetAvailabilityNode
AstAdfDatasetAvailabilityNode objects correspond directly to availability specifications for datasets in Azure Data Factory
AstAdfDatasetNode
AstAdfDatasetNode is the abstract base type for all Azure Data Factory Datasets.
AstAdfDatasetPartitionedByNode
AstAdfDatasetPartitionedByNode objects correspond directly to the Azure Data Factory partitionedBy property in various dataset types.
AstAdfDatasetPolicyNode
AstAdfDatasetPolicyNode objects correspond directly to the policy specifications for Azure Data Factory datasets.
AstAdfDatasetReferenceNode
The AstAdfDatasetReferenceNode type is a wrapper for a direct reference to an Azure Data Factory dataset object.
AstAdfDatasetStructureColumnNode
AstAdfDatasetStructureNode
AstAdfDatasetStructureNode objects correspond directly to structure specifications within 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.
AstAdfFormatBaseNode
AstAdfFormatBaseNode is the abstract base type for all Azure Data Factory format types.
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'.
AstAdfJsonFormatNode
AstAdfJsonFormatNode objects correspond directly to Azure Data Factory JsonFormat objects.
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.
AstAdfOrcFormatNode
AstAdfOrcFormatNode objects correspond directly to Azure Data Factory OrcFormat objects.
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.
AstAdfScheduleBaseNode
AstAdfScheduleNode is the base class for activity schedules and dataset availability in Azure Data Factory.
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.
AstAdfTextFormatNode
AstAdfTextFormatNode objects correspond directly to Azure Data Factory TextFormat objects.
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.
AstAdoNetConnectionNode
The ADO.NET connection connects to a data source that can be accessed via a .NET Framework data provider.
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.
AstAggregateColumnNode
The Aggregate Column transformation applies aggregate functions to specified column values and copies results to specified destination locations.
AstAggregateNode
The Aggregate transformation aggregates and groups values in a data set.
AstAggregateOutputPath
AstAggregateOutputPathNode is a special type of output path that is used to model output paths from a Aggregate transformation in a SQL Server Integration Services dataflow task. This output path includes the calculated columns it should produce.. Connections are made by referencing an output path from an appropriate input path.
AstAggregationDesignAttributeReferenceNode
The AstAggregationDesignAttributeReferenceNode type is a wrapper for a direct reference to a SQL Server Analysis Services dimension attribute fo use in an aggregation design.
AstAggregationDesignDimensionReferenceNode
The AstAggregationDesignDimensionReferenceNode type is a wrapper for a direct reference to a cube dimension for use in an aggregation design.
AstAggregationDesignNode
The AstAggregationDesignNode type corresponds directly to an aggregation design in SQL Server Analysis Services.
AstAggregationDimensionReferenceNode
The AstAggregationDimensionReferenceNode type is a wrapper for a direct reference to a cube dimension for use in an aggregation.
AstAggregationNode
The AstAggregationNode type corresponds directly to an individual aggregation in SQL Server Analysis Services.
AstAnalysisDatabasePermissionNode
The Data Source permission defines access rights to an Analysis Services database.
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.
AstAnalysisServicesConnectionMetadataNode
The SQL Server Analysis Services (SSAS) connection information node specifies supplemental information that is used by SSAS to connect to a given data source, usually in context of development and cube processing.
AstAnalysisServicesConnectionNode
The SQL Server Analysis Services connection connects to a server running an Analysis Services database or to an Analysis Services project.
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.
AstAnnotationNode
The AstAnnotationNode type is used to define an annotation item that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.
AstAttachedFileNode
The AstAttachedFileNode type is used to model related files that are attached to a SQL Server Integration Services package.
AstAttributeColumnBaseNode
AstAttributeColumnBaseNode is an abstract type that serves as the base type for all mappings between SQL Server Analysis Services dimension attributes and relational database table columns.
AstAttributeCustomRollupColumnBaseNode
AstAttributeCustomRollupColumnBaseNode is an abstract type that serves as the base type for all custom rollup column types for SQL Server Analysis Services dimension attributes.
AstAttributeCustomRollupColumnNode
The AstAttributeCustomRollupColumnNode type corresponds directly to an attribute custom rollup column in a SQL Server Analysis Services dimension attribute.
AstAttributeCustomRollupPropertiesColumnBaseNode
AstAttributeCustomRollupPropertiesColumnBaseNode is an abstract type that serves as the base type for all custom rollup properties column types for SQL Server Analysis Services dimension attributes.
AstAttributeCustomRollupPropertiesColumnNode
The AstAttributeCustomRollupPropertiesColumnNode type corresponds directly to an attribute custom rollup properties column in a SQL Server Analysis Services dimension attribute.
AstAttributeKeyColumnBaseNode
AstAttributeKeyColumnBaseNode is an abstract type that serves as the base type for all key column types for SQL Server Analysis Services dimension attributes.
AstAttributeKeyColumnNode
The AstAttributeKeyColumnNode type corresponds directly to an attribute key column in a SQL Server Analysis Services dimension attribute.
AstAttributeNameColumnBaseNode
AstAttributeNameColumnBaseNode is an abstract type that serves as the base type for all name column types for SQL Server Analysis Services dimension attributes.
AstAttributeNameColumnNode
The AstAttributeNameColumnNode type corresponds directly to an attribute name column in a SQL Server Analysis Services dimension attribute.
AstAttributeNode
AstAttributeNode corresponds directly to a SQL Server Analysis Services dimension attribute.
AstAttributeReferenceNode
The AstAttributeReferenceNode type is a wrapper for a direct reference to a SQL Server Analysis Services dimension attribute.
AstAttributeRelationshipNode
AstAttributeRelationshipNode corresponds directly to a SQL Server Analysis Services dimension attribute relationship. It describes parent/child relationships between attributes.
AstAttributeSnowflakeCustomRollupColumnNode
The AstAttributeSnowflakeCustomRollupColumnNode type corresponds directly to a snowflaked attribute custom rollup column in a SQL Server Analysis Services dimension attribute.
AstAttributeSnowflakeCustomRollupPropertiesColumnNode
The AstAttributeSnowflakeCustomRollupPropertiesColumnNode type corresponds directly to a snowflaked attribute custom rollup properties column in a SQL Server Analysis Services dimension attribute.
AstAttributeSnowflakeKeyColumnNode
The AstAttributeSnowflakeKeyColumnNode type corresponds directly to a snowflaked attribute key column in a SQL Server Analysis Services dimension attribute.
AstAttributeSnowflakeNameColumnNode
The AstAttributeSnowflakeNameColumnNode type corresponds directly to a snowflaked attribute name column in a SQL Server Analysis Services dimension attribute.
AstAttributeSnowflakeUnaryOperatorColumnNode
The AstAttributeSnowflakeUnaryOperatorColumnNode type corresponds directly to a snowflaked attribute unary operator column in a SQL Server Analysis Services dimension attribute.
AstAttributeSnowflakeValueColumnNode
The AstAttributeSnowflakeValueColumnNode type corresponds directly to a snowflaked attribute value column in a SQL Server Analysis Services dimension attribute.
AstAttributeTranslationNode
The AstAttributeTranslationNode type is used to define alternate language versions of attribute members associated with a dimension. These are used by client applications such as Microsoft Excel to show values for dimension metadata that are consistent with the language of the end-user.
AstAttributeUnaryOperatorColumnBaseNode
AstAttributeUnaryOperatorColumnBaseNode is an abstract type that serves as the base type for all unary operator column types for SQL Server Analysis Services dimension attributes.
AstAttributeUnaryOperatorColumnNode
The AstAttributeUnaryOperatorColumnNode type corresponds directly to an attribute unary operator column in a SQL Server Analysis Services dimension attribute.
AstAttributeValueColumnBaseNode
AstAttributeValueColumnBaseNode is an abstract type that serves as the base type for all value column types for SQL Server Analysis Services dimension attributes.
AstAttributeValueColumnNode
The AstAttributeValueColumnNode type corresponds directly to an attribute value column in a SQL Server Analysis Services dimension attribute.
AstAuditNode
The Audit transformation performs specified audits on the incoming dataflow rows and adds audit information to the outgoing dataflow rows.
AstAuditOutputColumnNode
The AstAuditOutputColumnNode type corresponds directly to an output column mapping definition in the SQL Server Integration Services dataflow audit component.
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.
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.
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.
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.
AstAzureStorageConnectionNode
The Azure Storage Connection connects to a Microsoft Azure bloc storage account.
AstAzureSubscriptionConnectionNode
The Azure Subscription Connection connects to a Microsoft Azure subscription.
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.
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.
AstBuildSettingsNode
AstBuildSettingsNode contains the settings that will be applied when the current project is built. This primarily includes target version information.
AstBulkInsertTaskNode
The Bulk Insert task is an efficient method of copying large amounts of data into a SQL Server table.
AstCacheColumnNode
The AstCacheColumnNode type corresponds directly to a column that is defined in a raw or cache file format definition in SQL Server Integration Services.
AstCacheConnectionNode
The Cache connection connects to a cache.
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.
AstCalculatedMemberNode
The AstCalculatedMemberNode type corresponds directly to the script definition for an MDX calculated member in SQL Server Analysis Services.
AstCalculationReferenceNode
The AstCalculationReferenceNode type is a wrapper for a direct reference to a calculation for use in a cube perspective.
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).
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.
AstCharacterMapColumnNode
The Character Map Column transformation specifies columns to convert and operations used to convert them.
AstCharacterMapNode
The Character Map transformation converts character data by applying string transformation operations.
AstCheckConstraintNode
Defines a Check constraint, which can be used to enforce that data in a table or column meets specific criteria.
AstCheckDatabaseIntegrityTaskNode
The Check Database Integrity task runs the DBCC CHECKDBT Transact- SQL command to verify the integrity of the database.
AstClientInitiatedTableNotificationProactiveCachingSourceNode
The AstClientInitiatedTableNotificationProactiveCachingSourceNode type corresponds directly to client initiated table notification for a proactive caching source in SQL Server Analysis Services.
AstColumnErrorHandlingNode
Defines the error handling defaults to apply to a specific output column
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.
AstColumnPermissionNode
The Column permission grants, denies, or revokes the permission to perform the following actions on a column. Such actions include Alter, Delete, Insert, Select, Update, and others.
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.
AstComponentConnectionReferenceNode
Defines the connection referenced from the custom component.
AstComponentErrorHandlingNode
Specifies the error handling defaults to apply to an entire component
AstComponentInputColumnNode
Defines an output column of an upstream component that is selected for use by a component
AstComponentInputPathNode
Defines a component input. This object is used with custom components.
AstComponentOutputPathNode
Defines an output for a custom component.
AstComponentResourceNode
The AstComponentResourceNode type is used for creating references to a SSIS dataflow component that has been modeled in the Biml project.
AstComponentScriptProjectInputBufferColumnNode
The AstComponentScriptProjectInputBufferColumnNode type corresponds directly to a dataflow column that is mapped into an input path column of a Script Component project. This column will be exposed for reading and/or writing in the script project user code.
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.
AstComponentScriptProjectOutputBufferColumnNode
The AstComponentScriptProjectOutputBufferColumnNode type corresponds directly to a dataflow column that is mapped into an output path column of a Script Component project. This column will be exposed for editing to the script project user code.
AstComponentScriptProjectOutputBufferNode
The AstComponentScriptProjectOutputBufferNode corresponds directly to output buffer column mappings within a SQL Server Integration Services dataflow Script Component.
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.
AstConditionalSplitNode
The Conditional Split transformation routes source data rows to different output paths by evaluating expressions.
AstConditionalSplitOutputPathNode
AstConditionalSplitOutputPathNode is a special type of output path that is used to model output paths from a Conditional Split transformation in a SQL Server Integration Services dataflow task. This output path includes an expression that determines which rows are assigned to this path. Connections are made by referencing an output path from an appropriate input path.
AstConfigurationValueNode
The AstConfigurationValueNode type corresponds directly to an individual value setting within a SQL Server Integration Services package configuration.
AstConnectionBaseNode
AstConnectionBaseNode is the base type for all connection types that are defined in the Biml framework.
AstConnectionReferenceBaseNode
The AstConnectionReferenceBaseNode type is a wrapper for a direct reference to a connection.
AstConnectionReferenceNode
The AstConnectionReferenceNode type is a wrapper for a direct reference to a connection. It includes information that can be added by Package references to the connection.
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.
AstCubeAttributeReferenceNode
The AstCubeAttributeReferenceNode type is a wrapper for a direct reference to a SQL Server Analysis Services dimension attribute for use in a cube dimension.
AstCubeCellPermissionNode
Cube Cell permission defines access rights to cube cells.
AstCubeDimensionAttributePermissionNode
The Cube Database Dimension Attribute permission defines access rights to database cube dimension attributes.
AstCubeDimensionBindingBaseNode
The AstCubeDimensionRegularBindingNode type is the base class for cube dimension bindings.
AstCubeDimensionBindingNode
The AstCubeDimensionBindingNode type describes a simplified regular dimension relationship between a measure group and a cube dimension in SQL Server Analysis Services. This binding type uses the defined keys and references on the dimension and fact tables to derive the relationship.
AstCubeDimensionFactBindingNode
The AstCubeDimensionFactBindingNode type describes a degenerate/fact dimension relationship between a measure group and a cube dimension that are defined on the same underlying table or DSV named query in SQL Server Analysis Services.
AstCubeDimensionManyToManyBindingNode
The AstCubeDimensionManyToManyBindingNode type describes a many-to-many dimension relationship between a measure group and a cube dimension through an intermediate factless fact table in SQL Server Analysis Services.
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.
AstCubeDimensionPermissionNode
The Cube Dimension permission defines access rights to the dimensions in a cube.
AstCubeDimensionReferenceBindingNode
The AstCubeDimensionReferenceBindingNode type describes a reference dimension relationship between a measure group and a cube dimension through an intermediate cube dimension in SQL Server Analysis Services.
AstCubeDimensionReferenceNode
AstCubeDimensionReferenceNode is an abstract type that serves as the base type for all context-specific cube dimension reference types.
AstCubeDimensionRegularBindingNode
The AstCubeDimensionRegularBindingNode type describes a regular dimension relationship between a measure group and a cube dimension in SQL Server Analysis Services. This binding type allows the column mapping between the fact and dimension to be explicitly defined.
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.
AstCubeMeasureGroupReferenceNode
The AstCubeMeasureGroupReferenceNode type is a wrapper for a direct reference to a SQL Server Analysis Services cube measure group for use in a perspective.
AstCubeNode
Cube objects correspond directly to SQL Server Analysis Services (SSAS) cubes, which offer a multidimensional data storage and query mechanism.
AstCubePermissionNode
The Cube permission defines access rights to a cube.
AstCubeProcessingConfigurationNode
The AstCubeProcessingConfigurationNode type describes cube processing options used by the SQL Server Integration Services Analysis Services Processing task.
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.
AstCubeReferenceNode
Defines the relationship between a CubeProject and a Cube.
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.
AstCustomLogProviderNode
SQL Server Integration Services includes several log providers that enable users to record a log of events that occur during package execution. You can also create a custom log provider.
AstCustomSsisConnectionNode
The AstCustomConnectionNode type supports custom and third party SQL Server Integration Services connection managers.
AstCustomTaskNode
The AstCustomTaskNode type supports custom and third party SQL Server Integration Services tasks.
AstDatabaseDimensionAttributePermissionNode
The Database Dimension Attribute permission defines access rights to database dimension attributes.
AstDatabaseDimensionPermissionNode
The Cube permission defines access rights to a cube.
AstDatabaseFileGroupNode
The AstDatabaseFileGroupNode type provides properties to configure a group of file used to store the contents of a database on the database server.
AstDatabaseFileGroupResourceNode
AstDatabaseFileGroupResourceNode is used for creating references to database file groups that have been modeled in the Biml project.
AstDatabaseFileNode
The AstDatabaseFileNode type provides properties to configure a file used to store the contents of a database on the database server.
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.
AstDatabasePermissionNode
The Database permission grants, denies, or revokes the permission to perform specified actions on a database. Such actions include Alter, Delete, Insert, Select, Update, and others.
AstDatabaseProcessingConfigurationNode
The AstDatabaseProcessingConfigurationNode type describes database processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstDatabaseTablePartitionSourceNode
The AstDatabaseTablePartitionSourceNode type describes all configuration information for a SQL Server Analysis Services partition whose source data is generated from a full database table.
AstDataConversionColumnNode
The Data Conversion Column transformation specifies the input columns to be converted, the data types to be used, and the output columns for the converted data.
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.
AstDataflowColumnBaseNode
AstDataflowColumnBaseNode is the base type for all SQL Server Integration Services dataflow task columns, including those that will original from file sources and caches.
AstDataflowColumnMappingNode
The Dataflow Column Mapping transformation moves data from a column in the source to a column in the destination and applies any specified transformations.
AstDataflowColumnNode
AstDataflowColumnNode is the base type for all SQL Server Integration Services dataflow task columns.
AstDataflowColumnOverrideNode
This class provides all of the options necessary to override dataflow column properties during emission of an SSIS dataflow path.
AstDataflowComponentOverrideNode
This class provides all of the options necessary to override dataflow component properties during emission of an SSIS dataflow task.
AstDataflowErrorHandlingNode
Defines generic error handling for dataflow objects
AstDataflowExternalColumnNode
The AstDataflowExternalColumnNode type corresponds directly to a dataflow column that describes metadata from a column defined in a remote data source in SQL Server Integration Services.
AstDataflowInputPathNode
AstDataflowInputPathNode is used to model input paths in a SQL Server Integration Services dataflow task. Connections are made by referencing an appropriate output path.
AstDataflowInputPathOverrideNode
This provides all of the options necessary to override dataflow input path properties during emission of an SSIS dataflow task.
AstDataflowMappedInputPathNode
AstDataflowMappedInputPathNode is used to model input paths in a SQL Server Integration Services dataflow task. Connections are made by referencing an appropriate output path. This type additionally permits the mapping of a column on an incoming row to a new column on the outgoing row.
AstDataflowOutputColumnNode
The AstDataflowOutputColumnNode type corresponds directly to a dataflow column that is mapped to a dataflow output path for passing row values in SQL Server Integration Services.
AstDataflowOutputPathNode
AstDataflowOutputPathNode is used to model output paths in a SQL Server Integration Services dataflow task. Connections are made by referencing an output path from an appropriate input path.
AstDataflowOutputPathOverrideNode
This provides all of the options necessary to override dataflow output path properties during emission of an SSIS dataflow task.
AstDataflowOverrideNode
This is an abstract type that serves as the base type for all dataflow property overrides.
AstDataflowOverridePropertyNode
This class provides options necessary to specify a generic property override for a target dataflow object.
AstDataflowPropertyNode
The AstDataflowPropertyNode type corresponds directly to a custom property that can be overriden with an expression on an output path or column in a dataflow task in SQL Server Integration Services.
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.
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.
AstDataReaderDestinationNode
The DataReader destination loads dataflow rows into an ADO.NET data reader for consumption by other applications or components.
AstDataSourcePermissionNode
The Data Source permission defines access rights to data sources in an Analysis Services database.
AstDbConnectionNode
The DB connection connects to a database.
AstDerivedColumnListNode
The Derived Column transformation applies expressions to input columns to generate new column values.
AstDerivedColumnNode
AstDerivedColumnNode enables the definition of new columns in a dataflow task within a Derived Columns transformation.
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).
AstDimensionalPermissionNode
AstDimensionalPermissionNode is an abstract type that serves as the base type for all SQL Server Analysis Services permission types in the Biml framework.
AstDimensionBindingColumnReferenceNode
Defines the fact table column binding of a dimension reference.
AstDimensionHierarchyLevelNode
AstDimensionHierarchyLevelNode corresponds directly to a SQL Server Analysis Services dimension hierarchy level.
AstDimensionHierarchyNode
AstDimensionHierarchyNode corresponds directly to a SQL Server Analysis Services dimension hierarchy.
AstDimensionHierarchyReferenceNode
The AstDimensionHierarchyReferenceNode type is a wrapper for a direct reference to a dimension hierarchy for use in a cube dimension or perspective.
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).
AstDimensionNamedBaseNode
AstDimensionNamedBaseNode is the base class for all attribute, relationship, hierarchy, and level elements that are bound to a dimension.
AstDimensionNode
Dimension objects include all of the capabilities of regular tables and additionally correspond directly to a Dimension in SQL Server Analysis Services (SSAS).
AstDimensionProcessingConfigurationNode
The AstDimensionProcessingConfigurationNode type describes dimension processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstDimensionProcessingNode
The Dimension Processing destination loads and processes an SQL Server Analysis Services dimension.
AstDimensionReferenceNode
Specifies the relationsip between a CubeProject and a Dimension.
AstDirectResourceNode
The AstDirectResourceNode type provides the facility to directly input text data for use in the referencing Biml object.
AstDqsCleansingColumnMappingNode
The AstDqsCleansingColumnMappingNode type corresponds directly to a column mapping in the SQL Server Integration Services DQS Cleansing transformation.
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.
AstDrillThroughActionNode
The AstDrillThroughActionNode type corresponds directly to a cube drill through action that is stored on the Analysis Services cube and executed by client applications such as Microsoft Excel.
AstDsvTablePartitionSourceNode
The AstDsvTablePartitionSourceNode type describes all configuration information for a SQL Server Analysis Services partition whose source data is generated from a data source view.
AstEnvironmentVariableResourceNode
This resource references an environment variable on the computer.
AstErrorConfigurationNode
The AstErrorConfigurationNode type defines how the SQL Server Analysis Services engine will respond to various potential error conditions while processing objects in the cube.
AstExcelDestinationNode
The Excel destination loads data into Microsoft Excel workbooks.
AstExcelOleDbConnectionNode
The Excel OLE DB connection connects to a Microsoft Excel data source.
AstExcelSourceNode
The Excel source extracts data from Microsoft Excel workbooks.
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.
AstExportColumnMappingNode
The AstExportColumnMappingNode type corresponds directly to a column mapping in the SQL Server Integration Services Export Column transformation.
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.
AstExternalDatabaseFileGroupResourceNode
AstExternalDatabaseFileGroupResourceNode is used for creating references to database file groups that have not been modeled in the Biml project.
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.
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).
AstFileColumnNode
AstFileColumnNode is the base type for all SQL Server Integration Services dataflow task columns that originate from a source file.
AstFileConnectionNode
The File connection can connect to existing files or folders or create files or folders if needed.
AstFileFormatNode
AstFileFormatNode is the base type for all flat file definition formats in the Biml framework.
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.
AstFlatFileColumnNode
The AstFlatFileColumnNode type corresponds directly to a column that is defined in a flat file format definition in SQL Server Integration Services.
AstFlatFileConnectionNode
The Flat File connection connects to a flat file.
AstFlatFileDestinationNode
The Flat File destination writes data to a flat text file in a format specified by a FlatFileFormat definition.
AstFlatFileFormatNode
The AstFlatFileFormatNode type corresponds directly to a flat file format definition that can be consumed by a dataflow flat file source in a SQL Server Integration Services dataflow.
AstFlatFileResourceNode
AstFlatFileResourceNode is used for creating references to flat file connections that have been modeled in the Biml project.
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.
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.
AstFtpConnectionNode
The FTP connection connects to a File Transfer Protocol (FTP) server.
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.
AstFuzzyGroupingColumnMappingNode
The Fuzzy Grouping Column Mapping transformation compares columns to identify duplicate data.
AstFuzzyGroupingNode
The Fuzzy Grouping transformation groups data set rows that contain similar values.
AstFuzzyLookupColumnMappingNode
The Fuzzy Lookup Column Mapping transformation compares columns using non-exact matching algorithms to find a matching row.
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.
AstHttpConnectionNode
The HTTP connection allows a package to use HTTP to connect to a Web server to send or receive files.
AstImportColumnMappingNode
The Import Column Mapping transformation specifies the columns in the data flow to which data is added and specifies whether the transformation expects a byte-order mark (BOM).
AstImportColumnNode
The Import Column transformation loads data from files into columns in a data flow.
AstIncrementalNotificationProactiveCachingSourceNode
The AstIncrementalNotificationProactiveCachingSourceNode type provides information to the Proactive Caching object about how to determine incremental processing progress.
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.
AstInputErrorHandlingNode
The AstInputErrorHandlingNode type corresponds directly to the error configuration settings for an input path in a SQL Server Integration Services data flow task component error handling configuration.
AstIsNullPatcherColumnNode
AstIsNullPatcherColumnNode is an abstract type that is used to define default value mappings that will replace null values in the specified dataflow column.
AstIsNullPatcherNode
The Is Null Patcher will rewrite the specified columns to a default value if they have a null value.
AstKpiNode
The AstKpiNode type corresponds directly to a Key Performance Indicator (KPI) in SQL Server Analysis Services.
AstKpiReferenceNode
The AstKpiReferenceNode type is a wrapper for a direct reference to a Key Performance Indication (KPI) for use in a cube perspective.
AstLogEventNode
The AstLogEventNode type corresponds directly to a log event in SQL Server Integration Services.
AstLogProviderBaseNode
AstLogProviderBaseNode is the base type for all log provider types available in the SQL Server Integration Services.
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.
AstLookupOutputColumnMappingNode
The Lookup Output Column Mapping defines how the lookup transformation will insert data from a matched item into the output row.
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.
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.
AstMdxFileNode
The AstMdxFileNode type enables script definition for an MDX script commnd in a SQL Server Analysis Services cube to be imported from an external file. This provides a facility for common MDX scripts that are shared across multiple cubes to be easily managed and shared from a central location.
AstMdxScriptCalculationPropertyNode
The AstMdxScriptCalculationPropertyNode type corresponds directly to a script calculation property in SQL Server Analysis Services.
AstMdxScriptItemNode
AstMdxScriptItemNode is the base type for all SQL Server Analysis Services script types.
AstMdxScriptNode
The AstMdxScriptNode type corresponds directly to a cube script container in SQL Server Analysis Services. While Business Intelligence Development Studio only exposes a single script container per cube, Analysis Services permits multiple script containers to be defined.
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).
AstMeasureGroupProcessingConfigurationNode
The AstMeasureGroupProcessingConfigurationNode type describes measure group processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstMeasureNode
AstMeasureNode corresponds directly to a measure in an Analysis Services cube measure group.
AstMeasureReferenceNode
The AstMeasureReferenceNode type is a wrapper for a direct reference to a measure for use in a cube measure group.
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.
AstMergeJoinKeyNode
The AstMergeJoinKeyNode type defines the names of the columns on the left and right input paths that will compose (at least in part) the join key for a SQL Server Integration Services Merge Join transformation.
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.
AstMetadataItemColumnNode
Metadata item column objects are used to create references to columns for that are primarily used by entity mappings.
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.
AstMetadataItemMappingNode
Metadata item mapping objects are used to specify the actual metadata used within a column mapping as part of a larger metadata model entity.
AstMetadataItemPropertyNode
Metadata item property objects are used to specify the actual property value metadata used within a metadata model.
AstMetadataItemRelationshipNode
Metadata item relationship objects are used to specify the item or row within the related entity from the metadata model that satisifes the relationship constraint for the parent metadata item.
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.
AstMetadataModelPermittedValueNode
Permitted value objects provide name/value mappings for allowed input values for metadata model properties.
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.
AstMetadataModelRelationshipFilteredLookupItemNode
Filtered lookup items are used by the editor UI to provide completion lists. Each filtered lookup item will provide configuration information for a completion list. These completion lists can reference each other. For example, a column relationship may provide fields for connection, object, and column. In this case, the object lookup completion list would only contain objects in the selected connection. Similarly, the column lookup completion list would only provide columns in the selected table.
AstMetadataModelRelationshipLookupItemNode
Lookup items are an abstract base class provided for backwards compatibility as additional types of filtered lookups are added in the future.
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.
AstMiningModelAlgorithmParameterMappingNode
AstMiningModelColumnNode
AstMiningModelFoldingParametersNode
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.
AstMiningModelProcessingConfigurationNode
The AstMiningModelProcessingConfigurationNodetype describes mining model processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstMiningStructureColumnNode
AstMiningStructureNode
This value displays the current cube state with respect to processing.
AstMiningStructureProcessingConfigurationNode
The AstMiningStructureProcessingConfigurationNode type describes mining structure processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstMsmqConnectionNode
The MSMQ connection allows a package to connect to a message queue.
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.
AstMultipleHashOutputColumnNode
The AstMultipleHashOutputColumnNode type is used to specify an output column for the Multiple Hash component. It includes a selection of hashing algorithm and a list of references to input columns whose values should be hashed to produce hashed values for this output column.
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.
AstNamedNode
AstNamedNode is the base type for all Biml language model classes that can be referenced by name and that will be entered into the symbol table for central tracking. It provides a variety of methods and properties that are useful to the language framework.
AstNamedSetNode
The AstNamedSetNode type corresponds directly to the script definition for an MDX named set in SQL Server Analysis Services.
AstNode
AstNode is the base type from which all other Biml language model classes derive. It provides a variety of methods and properties that are useful to the language framework.
AstNotifyOperatorTaskNode
The Notify Operator task sends notification messages via e-mail, pager, or net send to SQL Server Agent operators.
AstOdbcConnectionNode
The ODBC Connection specifies the settings necessary for an Open Database Connectivity (ODBC) adapter installed on the system to connect to a data source.
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.
AstOleDbCommandParameterNode
The OLE DB Command Parameter transformation maps an input column to an external column for use as an OLE DB command parameter.
AstOleDbConnectionNode
The OLE DB connection connects to a datasource that requires an OLE DB provider.
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.
AstOracleConnectionNode
The Oracle Connection specifies the settings necessary for the Attunity Oracle SSIS component to connect to a Oracle data source.
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.
AstOutputErrorHandlingNode
Defines the error handling defaults to apply to a specific output
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.
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.
AstPackageReferenceNode
Defines the relationship between a PackageProject and a 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.
AstPartitionFunctionNode
Defines a partition function for relational partitioning
AstPartitionNode
The AstPartitionNode type corresponds directly to a measure group partition in SQL Server Analysis Services.
AstPartitionProcessingConfigurationNode
The AstPartitionProcessingConfigurationNode type describes partition processing options used by the SQL Server Integration Services Analysis Services Processing task.
AstPartitionProcessingDestinationNode
The Partition Processing destination loads and processes a SQL Server Analysis Services partition.
AstPartitionSchemeNode
Defines a scheme for mapping partitions to filegroups.
AstPartitionSourceNode
AstPartitionSourceNode is an abstract type that serves as the base type for all types that describe from where a SQL Server Analysis Services partition sources its data.
AstPercentageSamplingNode
The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input.
AstPermissionBaseNode
AstPermissionGrantBaseNode
AstPermissionBaseNode is an abstract type that serves as the base type for all permission types in the Biml framework.
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.
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.
AstPerspectiveAttributeReferenceNode
The AstPerspectiveAttributeReferenceNode type is a wrapper for a direct reference to a SQL Server Analysis Services dimension attribute for use in a cube perspective.
AstPerspectiveCubeDimensionReferenceNode
The AstPerspectiveCubeDimensionReferenceNode type is a wrapper for a direct reference to a cube dimension for use in a cube perspective.
AstPerspectiveNode
The AstPerpectiveNode type corresponds directly to a cube perspective in SQL Server Analysis Services. Note that perspectives are only available in Developer and Enterprise editions.
AstPivotInputColumnNode
The Pivot Input Column transformation defines the input columns that are used in the pivot operation.
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.
AstPivotOutputColumnNode
The Pivot Output Column transformation defines the output columns that are used in the pivot operation.
AstPrincipalMemberNode
Specify members for a principal node.
AstPrincipalNode
AstPrincipalNode defines a security principal that can be used across relational or Analysis Services databases.
AstPrincipalReferenceNode
Defines the relationship between a CubeProject and a Principal.
AstProactiveCachingIncrementalNotificationNode
The AstProactiveCachingIncrementalNotificationNode type corresponds directly to a proactive caching incremental notification configuration in SQL Server Analysis Services.
AstProactiveCachingNode
The AstProactiveCachingNodecorresponds directly to a proactive caching configuration definition in SQL Server Analysis Services.
AstProactiveCachingQueryNotificationNode
The AstProactiveCachingQueryNotificationNode type corresponds directly to a proactive caching query notification configuration in SQL Server Analysis Services.
AstProactiveCachingSourceNode
AstProactiveCachingSourceNode is an abstract type that serves as the base type for all proactive caching source definition types in SQL Server Analysis Services.
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.
AstProfilerLogProviderNode
The SQL Server Profiler log provider writes traces that can be viewed using SQL Server Profiler. The default file name extension for these files is .trc.
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.
AstPropertyExpressionNode
The AstPropertyExpressionNode type provides the ability to map a SQL Server Integration Services expression value onto a property.
AstPropertyNode
The AstPropertyNode type corresponds directly to a property that can be overriden with an expression in a SQL Server Integration Services task.
AstQueryNotificationProactiveCachingSourceNode
The AstQueryNotificationProactiveCachingSourceNode type provides information to the Proactive Caching object about which query to execute to determine whether a data source has been modified.
AstQueryPartitionSourceNode
The AstQueryPartitionSourceNode type describes all configuration information for a SQL Server Analysis Services partition whose source data is generated from the results of a SQL query.
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.
AstRawFileFormatNode
The AstRawFileFormatNode type corresponds directly to a raw file format definition that can be consumed by a dataflow raw file source or a lookup cache in a SQL Server Integration Services dataflow.
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.
AstRelationalPermissionNode
AstRelationalPermissionNode is an abstract type that serves as the base type for all SQL Server relational database permission types in the Biml framework.
AstReorganizeIndexTaskNode
The Reorganize Index task rearranges index pages to improve their search order.
AstReportActionNode
The AstReportActionNode type corresponds directly to a cube report action that is stored on the Analysis Services cube and executed by client applications such as Microsoft Excel.
AstReportActionParameterMappingNode
The AstReportActionParameterMappingNode type provides the capability to map a named Reporting Services parameter onto a text value.
AstResultMappingNode
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.
AstRootNode
AstRootNode serves as the root of the entire project tree. Anything that can be defined in a Biml project must be a descendant of the AstRootNode, and all constructs in the project can be reached by following a path through the child properties starting at the AstRootNode.
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.
AstScdTypeColumnMappingNode
The SCD Type Column Mapping defines behaviors for how individual column values will be treated when changes are detected from previous values.
AstSchemaNode
Schema objects correspond directly to SQL Server schemas, which are logical containers for tables, stored procedures, views, and other database objects.
AstSchemaPermissionNode
The Schema permission grants, denies, or revokes the permission to perform specified actions on a schema. Such actions include Alter, Delete, Insert, Select, Update, and others.
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.
AstScriptCommandNode
The AstScriptCommandNode type corresponds directly to the script definition for an MDX script commnd in SQL Server Analysis Services.
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.
AstScriptProjectAssemblyReferenceNode
The AstScriptProjectAssemblyReferenceNode type corresponds directly to a .NET assembly reference in a SQL Server Integration Services script project.
AstScriptProjectExternalFileNode
The AstScriptProjectExternalFileNode type models a project file that already exists somewhere on the filesystem of the build machine and is used to build a SQL Server Integration Services script project.
AstScriptProjectFileBaseNode
The AstScriptProjectFileBaseNode is used as the abstract base class for all of the types of files that can be referenced by an SSIS script project.
AstScriptProjectFileNode
The AstScriptProjectFileNode type models a project file that is used to build a SQL Server Integration Services script project.
AstScriptProjectNode
The AstScriptProjectNode is the base class used for all SQL Server Integration Services script project types.
AstScriptProjectResourcesNode
The AstScriptProjectSettingsNode type is used to model embedded resources that can be leveraged by SQL Server Integration Services script projects.
AstScriptProjectSettingsNode
The AstScriptProjectSettingsNode type is used to model application settings that can be leveraged by SQL Server Integration Services script projects.
AstScriptProjectVariableReferenceNode
The AstScriptProjectVariableReferenceNode type is a wrapper for a direct reference to a SQL Server Integration Services package variable for use in a script project.
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.
AstSmtpConnectionNode
The SMTP connection connects to a Simple Mail Transfer Protocol (SMTP) server.
AstSortColumnNode
The Sort transformation sorts input data in the specified order and then copies the sorted data to an output file. The sort order of columns is indicated by numbering.
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).
AstSqlServerCompactConnectionNode
The SQL Server Compact connection connects to a SQL Server Compact database.
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.
AstSqlServerDqsConnectionNode
The SQL Server DQS connection connects to a Microsoft SQL Server Data Quality Service (DQS) instance.
AstSqlServerLogProviderNode
The SQL Server log provider writes log entries to the sysssislog table in a SQL Server database.
AstSqlServerManagementConnectionNode
The SQL Server connection connect sto a SQL Server database.
AstSqlServerPdwConnectionNode
The SQL Server PDW connection connects to a Microsoft SQL Server Parallel Data Warehouse (PDW) appliance. In later versions, PDW is rebranded as the Microsoft Analytics Platform System.
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.
AstSqlServerTableNotificationProactiveCachingSourceNode
The AstSqlServerTableNotificationProactiveCachingSourceNode corresponds directly to SQL Server Table Notification Source for proactive caching in SQL Server Analysis Services.
AstSsisAnnotationNode
AstSsisAnnotationNode corresponds directly to a SQL Server Integration Services design surface text annotation.
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.
AstSsisControlFlowPartResourceNode
The AstSsisControlFlowPartResourceNode type is used for creating references to a SSIS control flow part that has been modelled in the Biml project.
AstSsisPackagePartBaseNode
The Package Part Base type provides an abstract base type for all SSIS package parts.
AstSsisPackagePartReferenceNode
Defines the relationship between a PackageProject and a Package Part.
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.
AstStandardActionNode
The AstStandardActionNode type corresponds directly to a cube standard action that is stored on the Analysis Services cube and executed by client applications such as Microsoft Excel.
AstStaticSourceColumnValueNode
The AstStaticSourceColumnValueNode type is used to define a single column value within a row of data that will populate a table through its static source. Static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstStaticSourceRowNode
The AstStaticSourceRowNode type is used to define a full row of data that will populate a table through its static source. Static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstStoredProcColumnNode
The AstStoredProcColumnNode is used to define the input and output columns that will be exposed by the parent Stored Procedure.
AstStoredProcedurePermissionNode
The Stored Procedure permission grants, denies, or revokes the permission to perform specified actions on a stored procedure. Such actions include Alter, Delete, Insert, Select, Update, and others.
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.
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.
AstTableColumnReferenceNode
AstTableColumnReferenceNode is the base type for all column references in the Biml framework. It is used for eample in references to table columns from table indexes and keys.
AstTableColumnResourceNode
This resource references a column from a table in the model.
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.
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.
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.
AstTableHintParameterNode
The AstTableHintParameterNode type corresponds directly to a table or query hint in SQL Server.
AstTableIdentityNode
AstTableIdentityNode is an abstract type that represents both an identity expression and optionally a primary key on a table in a SQL Server relational database.
AstTableIndexColumnNode
The AstTableIndexColumnNode corresponds directly to a column reference from a parent table index in SQL Server.
AstTableIndexLeafNode
The AstTableIndexLeafNode corresponds directly to a column include reference from a parent table index in SQL Server.
AstTableIndexNode
AstTableIndexNode corresponds directly to a SQL Server relational database index.
AstTableKeyBaseNode
AstTableKeyBaseNode is the base node for all types of keys and constraints that can be defined in a SQL Server relational database.
AstTableKeyColumnNode
The AstTableKeyColumnNode corresponds directly to a column reference from a parent table key in SQL Server.
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.
AstTableNotificationProactiveCachingSourceNode
AstTableNotificationProactiveCachingSourceNode is an abstract type that serves as the base type for all table notification source types for proactive caching in SQL Server Analysis Services.
AstTablePermissionNode
The Table permission grants, denies, or revokes the permission to perform specified actions on a table. Such actions include Alter, Delete, Insert, Select, Update, and others.
AstTablePrimaryKeyNode
AstTablePrimaryKeyNode is an abstract type that represents a primary key constraint on a table in a SQL Server relational database.
AstTableResourceNode
The AstTableResourceNode type is used for creating references to a table that has been modeled in the Biml project.
AstTableSourceBaseNode
AstTableSourceBaseNode is the base type for all table source definitions in Biml.
AstTableStaticSourceNode
The AstTableStaticSourceNode type enables the definition of static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstTableUniqueKeyNode
AstTableUniqueKeyNode is an abstract type that represents a unique column(s) constraint on a table in a SQL Server relational database.
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.
AstTabularKpiNode
Tabular KPI objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model Key Performance Indicators (KPIs), which allow measures to be annotated with information about targets, statuses, and trends 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).
AstTabularMetadataReferenceNode
Defines the relationship between a Tabular Model and the constituent Tabular Metadata nodes for each included table.
AstTabularModelNode
Tabular model objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Models, which offer a tabular data storage and query mechanism.
AstTabularModelPermissionNode
The tabular model permission grants read, refresh, readRefresh, or administrator access to the model.
AstTabularModelReferenceNode
Defines the relationship between a TabularProject and a TabularModel.
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.
AstTabularPerspectiveColumnReferenceNode
Reference a tabular column to be included in the perspective.
AstTabularPerspectiveNode
Tabular perspective objects correspond directly to SQL Server Analysis Services (SSAS) Tabular Model perspectives, specify permissions for models.
AstTabularPerspectiveTableReferenceNode
Reference a tabular table to be included in the perspective.
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.
AstTabularRelationshipNode
AstTabularTablePermissionNode
The tabular table permission grants access to specific tables in a model.
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.
AstTaskScriptProjectNode
The AstTaskScriptProjectNode corresponds directly to the project embedded within a SQL Server Integration Services Script Task.
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.
AstTeradataConnectionNode
The Teradata Connection specifies the settings necessary for the Attunity Teradata SSIS component to connect to a Teradata data source.
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.
AstTermLookupColumnNode
The Term Lookup Column Mapping transformation defines how the parent transformation will examine a column having text to find terms stored in an appropriate data set.
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.
AstTextLogProviderNode
The Text log provider writes log entries in comma-separated value (CSV) format to ASCII text files with the file name extension of .log.
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.
AstTransformationNode
AstTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml.
AstTranslationNode
The AstTranslationNode type is used to define alternate language versions of measure groups, measures, cube dimension, perspectives, KPIs, actions, named sets, and calculated members. These are used by client applications such as Microsoft Excel to show values for dimension metadata that are consistent with the language of the end-user.
AstUnionAllNode
The Union All transformation combines rows from multiple input paths into a single output path, using column mappings where necessary.
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.
AstUnpivotColumnNode
The Unpivot Column transformation expands values from multiple columns in a single row into multiple rows in a single column.
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.
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.
AstViewNode
Defines a view, based on a SELECT statement and additional metadata.
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.
AstWindowsEventLogProviderNode
The Windows Event log provider writes log entries to the application log in the Windows Event log on the local computer.
AstWmiConnectionNode
The WMI connection uses Windows Management Instrumentation (WMI) to connect to an enterprise environment.
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.
AstXmlLogProviderNode
The XML File log provider writes log entries to an XML file.
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.