Documentation

Biml API Reference
Varigence.Languages.Biml.Transformation Namespace
Classes
  Parent Type Summary
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.
AstDataflowColumnNode
AstDataflowColumnNode is the base type for all SQL Server Integration Services dataflow task columns.
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.
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.
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.
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.
AstTransformationNode
AstTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml.
AstDataflowErrorHandlingNode
Defines generic error handling for dataflow objects
AstComponentErrorHandlingNode
Specifies the error handling defaults to apply to an entire component
AstOutputErrorHandlingNode
Defines the error handling defaults to apply to a specific output
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.
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.
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.
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.
AstAggregateColumnNode
The Aggregate Column transformation applies aggregate functions to specified column values and copies results to specified destination locations.
AstFuzzyGroupingColumnMappingNode
The Fuzzy Grouping Column Mapping transformation compares columns to identify duplicate data.
AstUnpivotColumnNode
The Unpivot Column transformation expands values from multiple columns in a single row into multiple rows in a single column.
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.
AstCharacterMapColumnNode
The Character Map Column transformation specifies columns to convert and operations used to convert them.
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.
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).
AstPivotInputColumnNode
The Pivot Input Column transformation defines the input columns that are used in the pivot operation.
AstOleDbCommandParameterNode
The OLE DB Command Parameter transformation maps an input column to an external column for use as an OLE DB command parameter.
AstPivotOutputColumnNode
The Pivot Output Column transformation defines the output columns that are used in the pivot operation.
AstFuzzyLookupColumnMappingNode
The Fuzzy Lookup Column Mapping transformation compares columns using non-exact matching algorithms to find a matching row.
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.
AstScdTypeColumnMappingNode
The SCD Type Column Mapping defines behaviors for how individual column values will be treated when changes are detected from previous values.
AstLookupOutputColumnMappingNode
The Lookup Output Column Mapping defines how the lookup transformation will insert data from a matched item into the output row.
AstComponentOutputPathNode
Defines an output for a custom component.
AstColumnErrorHandlingNode
Defines the error handling defaults to apply to a specific output column
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.
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.
AstDataflowComponentOverrideNode
This class provides all of the options necessary to override dataflow component properties during emission of an SSIS dataflow task.
AstDataflowOutputPathOverrideNode
This provides all of the options necessary to override dataflow output path properties during emission of an SSIS dataflow task.
AstDataflowColumnOverrideNode
This class provides all of the options necessary to override dataflow column properties during emission of an SSIS dataflow path.
AstDataflowInputPathOverrideNode
This provides all of the options necessary to override dataflow input path properties during emission of an SSIS dataflow task.
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.
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.
AstComponentInputPathNode
Defines a component input. This object is used with custom components.
AstComponentInputColumnNode
Defines an output column of an upstream component that is selected for use by a component
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.
AstIsNullPatcherNode
The Is Null Patcher will rewrite the specified columns to a default value if they have a null value.
AstIsNullPatcherColumnNode
AstIsNullPatcherColumnNode is an abstract type that is used to define default value mappings that will replace null values in the specified dataflow column.
AstOleDbCommandNode
The OLE DB command transformation executes SQL statements to access and transform external data.
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.
AstConditionalSplitNode
The Conditional Split transformation routes source data rows to different output paths by evaluating expressions.
AstMulticastNode
The Multicast Transformation creates multiple copies of source data and distributes them to multiple output paths.
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.
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.
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.
AstTermExtractionNode
The Term Extraction transformation extracts terms from input text columns and directs the terms to output text columns.
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.
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.
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.
AstCopyColumnNode
The Copy Column transformation copies input columns and uses them to create new columns in the transformation output.
AstDataMiningQueryNode
The Data Mining Query transformation runs a Data Mining Extensions (DMX) querie against a specified data mining model.
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.
AstAggregateNode
The Aggregate transformation aggregates and groups values in a data set.
AstExportColumnNode
The Export Column transformation exports column values from rows in a data set to files.
AstExportColumnMappingNode
The AstExportColumnMappingNode type corresponds directly to a column mapping in the SQL Server Integration Services Export Column transformation.
AstPercentageSamplingNode
The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input.
AstRowSamplingNode
The Row Sampling transformation generates a sample data set by randomly selecting a specified number of data flow rows from the input.
AstCharacterMapNode
The Character Map transformation converts character data by applying string transformation operations.
AstFuzzyGroupingNode
The Fuzzy Grouping transformation groups data set rows that contain similar values.
AstSortNode
The Sort transformation sorts input data in the specified order and then copies the sorted data to an output file.
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.
AstImportColumnNode
The Import Column transformation loads data from files into columns in a data flow.
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.
AstScriptComponentTransformationNode
The Script Component Transformation type corresponds directly to a SQL Server Integration Services script component with both an input buffer and output buffers.
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.
AstCdcSplitterNode
The CDC Splitter component partitions rows from a CDC Source component based on its status as an inserted, updated, or deleted row.
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.
AstDqsCleansingColumnMappingNode
The AstDqsCleansingColumnMappingNode type corresponds directly to a column mapping in the SQL Server Integration Services DQS Cleansing transformation.
AstDataMiningModelTrainingNode
The Data Mining Model Training destination is used to train data models in an Analysis Services cube.
AstDimensionProcessingNode
The Dimension Processing destination loads and processes an SQL Server Analysis Services dimension.
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).
AstXmlSourceNode
The XML source reads an XML data file, optionally validating it, and creates a data flow output rows with the resulting data.
AstOleDbSourceNode
The OleDbSource reads a data source using one of the OLEDB adapters available on the host system.
AstExcelSourceNode
The Excel source extracts data from Microsoft Excel workbooks.
AstFlatFileSourceNode
The Flat File Source reads data from a flat text file in a format specified by a FlatFileFormat definition.
AstAdoNetSourceNode
The ADO.NET Source reads data from a ADO.NET-compliant database that uses a database table or view.
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.
AstScriptComponentSourceNode
The Script Component Source type corresponds directly to a SQL Server Integration Services script component with output buffers.
AstCustomComponentSourceNode
Defines a custom source component.
AstComponentConnectionReferenceNode
Defines the connection referenced from the custom component.
AstOdbcSourceNode
The ODBC Source reads a data source using one of the ODBC adapters available on the host system.
AstOracleSourceNode
The Oracle Source reads an Oracle data source using the Attunity Oracle Connector.
AstTeradataSourceNode
The Teradata Source reads a Teradata data source using the Attunity Teradata Connector.
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.
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.
AstUnionAllNode
The Union All transformation combines rows from multiple input paths into a single output path, using column mappings where necessary.
AstMergeJoinNode
The Merge Join transformation merges data from two data sets by using a join.
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.
AstMergeNode
The Merge transformation combines date from two sorted data sets into a single data set.
AstCustomComponentNode
The Custom Component transformation represents a custom component in SSIS.
Enumerations
  Parent Type Summary
SsisDataflowPropertyDataType
Provides options for the data type of SSIS dataflow properties.
SsisComponentPropertyPersistState
Determines how a custom property is persisted in the package XML file.
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.
TruncationRowDisposition
The TruncationRowDisposition enumeration provides options for how a dataflow component should handle unanticipated truncation of data values.
FuzzyGroupingTransformNumeralOption
The FuzzyGroupingTransformNumeralOption enumeration provides options for how numeral values within columns should be compared by a Fuzzy Grouping Transformation.
FuzzyGroupingMatchType
The FuzzyGroupingMatchType enumeration provides options for how a SQL Server Integration Services Fuzzy Grouping transformation will handle a column comparison.
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.
PivotUsage
The PivotUsage enumeration provides options for the role of an input column in a SQL Server Integration Services Pivot transformation.
TermLookupInputUsageType
The TermLookupInputUsageType enumeration provides options for how an input column to the Term Lookup transformation are handled.
ScdColumnMappingType
The ScdColumnMappingType enumeration provides options for how changes to column values are handled by the Slowly Changing Dimension transformation.
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.
DataflowColumnUsageType
Provides options for specifying whether a dataflow input path column is read only or read/write.
DataflowPathAnnotation
Provides options for specifying the dataflow path annotation label that should be displayed alongside the referenced dataflow path on the BIDS/SSDT design surface.
CacheMode
The CacheMode enumeration provides options for what type of caching should be performed by a lookup dataflow component.
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.
SlowlyChangingDimensionIncomingRowChangeType
The SlowlyChangingDimensionIncomingRowChangeType enumeration provides options for how incoming rows should be handled by a Slowly Changing Dimension transformation.
TermExtractionTransformTermType
The TermExtractionTransformTermType enumeration provides options for the type of terms to extract in a SQL Server Integration Services Term Extraction 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.
AuditTransformAuditType
The AuditTransformAuditType provides a list of system variables that can be stored along with audit information in the Audit Transformation.
FuzzyLookupTransformMatchIndexOption
The FuzzyLookupTransformMatchIndexOption enumeration provides options for how match indexes into the reference dataset from row matches are saved to the index table.
DimensionProcessingDestinationProcessingType
XmlIntegerMapping
Defines how XML integer types are mapped.
OdbcCharColumnMapping
Provides options for mapping multibyte character data to Unicode or ANSI types during an ODBC data load.
OdbcNumericMapping
Provides options for mapping numeric data to either character or numeric types during an ODBC data load.
TeradataDetailedTracingLevel
Provides options for which trace messages should be collected and logged during a TPT data load.
TeradataBufferMode
Provides options for setting the buffering mode during Teradata extracts and loads.
CdcProcessingMode
The CDC Processing Mode enumeration provides options for the rows that should be returned by a CDC Source component.
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.
MergeJoinTransformJoinType
The MergeJoinTransformJoinType enumeration provides options for what type of join to perform in a SQL Server Integration Services Merge Join transformation.
TeradataReplicationOverride
Provides options for setting the replication mode of the Teradata server during a TPT data load.
SqlServerPdwLoadingMode
The SQL Server PDW Loading Mode enumeration provides options for how data should be loaded into a PDW instance via the SQL Server PDW Destination component.
External Classes

This namespace has no external classes.

Extension Methods

This namespace has no extension methods.