| 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. |
| 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. |
| AstAzureBlobSourceNode | The Azure blob destination reads data from Azure blob storage. |
| AstAzureDataLakeStoreSourceNode | The Azure Data Lake Store Source reads data from an Azure Data Lake Store. |
| 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. |
| 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. |
| 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. |
| 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. |
| AstCloudSourceBaseNode | The Cloud Source base model represents both HDFS and Azure Data Lake Store Sources. |
| AstColumnErrorHandlingNode | Defines the error handling defaults to apply to a specific output 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. |
| 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. |
| AstCopyColumnNode | The Copy Column transformation copies input columns and uses them to create new columns in the transformation output. |
| AstCustomComponentNode | The Custom Component transformation represents a custom component in SSIS. |
| AstCustomComponentSourceNode | Defines a custom source component. |
| 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. |
| AstDataMiningQueryNode | The Data Mining Query transformation runs a Data Mining Extensions (DMX) querie against a specified data mining model. |
| AstDataStreamingColumnMappingNode | The Lookup Output Column Mapping defines how the lookup transformation will insert data from a matched item into the output row. |
| 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. |
| 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. |
| AstExcelSourceNode | The Excel source extracts data from Microsoft Excel workbooks. |
| 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. |
| AstFlatFileSourceNode | The Flat File Source reads data from a flat text file in a format specified by a FlatFileFormat definition. |
| 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. |
| AstHdfsFileSourceNode | The HDFS Source reads data from an Hadoop cluster. |
| 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. |
| 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. |
| 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. |
| 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. |
| AstMulticastNode | The Multicast Transformation creates multiple copies of source data and distributes them to multiple output paths. |
| 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. |
| AstODataSourceNode | The OData Source reads data from an OData connection. |
| AstOdbcSourceNode | The ODBC Source reads a data source using one of the ODBC adapters available on the host system. |
| 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. |
| AstOleDbSourceNode | The OleDbSource reads a data source using one of the OLEDB adapters available on the host system. |
| 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 |
| AstPercentageSamplingNode | The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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). |
| 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. |
| AstTheobaldXtractSapSourceNode | The Theobald XTRACT Source will connect to an SAP database to extract records from a specified table. |
| AstTheobaldXtractSourceColumnMappingNode | The Lookup Output Column Mapping defines how the lookup transformation will insert data from a matched item into the output row. |
| AstTransformationNode | AstTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml. |
| AstUnionAllNode | The Union All transformation combines rows from multiple input paths into a single output path, using column mappings where necessary. |
| 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. |
| AstXmlSourceNode | The XML source reads an XML data file, optionally validating it, and creates a data flow output rows with the resulting data. |