BIML API Reference
Varigence.Languages.Biml.Transformation Namespace
Classes
| Name | Summary | |
|---|---|---|
 | 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. |
| 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. |
| 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. |
| AstColumnErrorHandlingNode | Defines the error handling defaults to apply to a specific output column |
| AstComponentErrorHandlingNode | Specifies the error handling defaults to apply to an entire 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 XML source reads an XML data file, creates output for each element in the file, and writes it to the specified output file. |
| 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. |
| AstQuerySourceNode | The Query Source is an abstracted source that will correctly create an OLE DB Source or ADO.NET Source depending on the type of connection that is supplied. |
| 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). |
| 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. |
| 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. |
Enumerations
| Name | Summary | |
|---|---|---|
 | AggregateTransformOperation | The AggregateTransformOperation enumeration provides options for which aggregation operation will be used in a SQL Server Integration Services Aggregate transformation. |
| AggregateTransformScale | The AggregateTransformScale enumeration provides options to specify the rough count or scale of items that will be processed. |
| AuditTransformAuditType | The AuditTransformAuditType provides a list of system variables that can be stored along with audit information in the Audit Transformation. |
| CacheMode | The CacheMode enumeration provides options for what type of caching should be performed by a lookup dataflow component. |
| CharacterMappingOptions | Character Mapping Options describe an individual text transformation operation that can be performed on a string value. This enumeration is normally used in a flags property so that multiple transformations can be specified at once. |
| ComparisonFlags | The ComparisonFlags enumeration provides options for how character values are compared. Multiple values can be selected simultaneously. |
| ErrorRowDisposition | The ErrorRowDisposition enumeration provides options for how a dataflow component should handle errors that are encountered during execution. |
| FuzzyGroupingMatchType | The FuzzyGroupingMatchType enumeration provides options for how a SQL Server Integration Services Fuzzy Grouping transformation will handle a column comparison. |
| FuzzyGroupingTransformNumeralOption | The FuzzyGroupingTransformNumeralOption enumeration provides options for how numeral values within columns should be compared by a Fuzzy Grouping Transformation. |
| FuzzyLookupTransformMatchIndexOption | The FuzzyLookupTransformMatchIndexOption enumeration provides options for how match indexes into the reference dataset from row matches are saved to the index table. |
| LookupNoMatchBehavior | The LookupNoMatchBehavior enumeration provides options for how the lookup component should handle rows where there was a failure to find a match in the lookup operation. |
| MergeJoinTransformJoinType | The MergeJoinTransformJoinType enumeration provides options for what type of join to perform in a SQL Server Integration Services Merge Join transformation. |
| PivotUsage | The PivotUsage enumeration provides options for the role of an input column in a SQL Server Integration Services Pivot transformation. |
| RawFileDestinationWriteOption | The RawFileDestinationWriteOption enumeration provides options for how the SQL Server Integration Services Raw File Destination transformation should behave when the output file has the same name as an existing file. |
| ScdColumnMappingType | The ScdColumnMappingType enumeration provides options for how changes to column values are handled by the Slowly Changing Dimension transformation. |
| SlowlyChangingDimensionIncomingRowChangeType | The SlowlyChangingDimensionIncomingRowChangeType enumeration provides options for how incoming rows should be handled by a Slowly Changing Dimension transformation. |
| TermExtractionTransformScoreType | The TermExtractionTransformScoreType enumeration provides options for the type of score that will be associated with an extracted term in a SQL Server Integration Services Term Extraction transformation. |
| TermExtractionTransformTermType | The TermExtractionTransformTermType enumeration provides options for the type of terms to extract in a SQL Server Integration Services Term Extraction transformation. |
| TermLookupInputUsageType | The TermLookupInputUsageType enumeration provides options for how an input column to the Term Lookup transformation are handled. |
| TruncationRowDisposition | The TruncationRowDisposition enumeration provides options for how a dataflow component should handle unanticipated truncation of data values. |