Documentation

Biml API Reference
BimlStudio 2017

This specifies the input path that will be used by this dataflow component. If an input path is not specified, the dataflow component will attempt to automatically discover an appropriate input path based on the surrounding dataflow.
Assembly:
Biml (in Biml.dll)
Language Element:
AstSingleInTransformationNode is an abstract type, so it does not have a corresponding Biml language element.
.NET API Metadata
Default Value:
Required:
False
Virtual:
False
Types Containing This Property
  Parent Type Summary
AstAdoNetDestinationNode
The ADO.NET destination loads data into a ADO.NET-compliant database that uses a database table or view.
AstAggregateNode
The Aggregate transformation aggregates and groups values in a data set.
AstAuditNode
The Audit transformation performs specified audits on the incoming dataflow rows and adds audit information to the outgoing dataflow rows.
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.
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.
AstCdcSplitterNode
The CDC Splitter component partitions rows from a CDC Source component based on its status as an inserted, updated, or deleted row.
AstCharacterMapNode
The Character Map transformation converts character data by applying string transformation operations.
AstConditionalSplitNode
The Conditional Split transformation routes source data rows to different output paths by evaluating expressions.
AstCopyColumnNode
The Copy Column transformation copies input columns and uses them to create new columns in the transformation output.
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.
AstDataMiningQueryNode
The Data Mining Query transformation runs a Data Mining Extensions (DMX) querie against a specified data mining model.
AstDataReaderDestinationNode
The DataReader destination loads dataflow rows into an ADO.NET data reader for consumption by other applications or components.
AstDerivedColumnListNode
The Derived Column transformation applies expressions to input columns to generate new column values.
AstDestinationTransformationNode
AstDestinationTransformationNode is the base type that is used for all SQL Server Integration Services dataflow transformations/components in Biml that are destinations (i.e. no non-error output paths).
AstDqsCleansingNode
The DQS Cleansing transformation replaces values of incoming data flow columns with corresponding values that have been corrected using rules specified in a Microsoft SQL Server Data Quality Services (DQS) instance.
AstExcelDestinationNode
The Excel destination loads data into Microsoft Excel workbooks.
AstExportColumnNode
The Export Column transformation exports column values from rows in a data set to files.
AstFlatFileDestinationNode
The Flat File destination writes data to a flat text file in a format specified by a FlatFileFormat definition.
AstFuzzyGroupingNode
The Fuzzy Grouping transformation groups data set rows that contain similar values.
AstFuzzyLookupNode
The Fuzzy Lookup transformation looks up values in a reference data set by using fuzzy matching. That is, matches can be close rather than exact.
AstImportColumnNode
The Import Column transformation loads data from files into columns in a data flow.
AstIsNullPatcherNode
The Is Null Patcher will rewrite the specified columns to a default value if they have a null value.
AstLookupNode
The Lookup transformation combines data in input columns with data in columns in a reference data set. It is the data flow equivalent of a SQL join.
AstMulticastNode
The Multicast Transformation creates multiple copies of source data and distributes them to multiple output paths.
AstOdbcDestinationNode
The ODBC Destination loads data into an ODBC-compliant database that uses a database table, a view, or an SQL command.
AstOleDbCommandNode
The OLE DB command transformation executes SQL statements to access and transform external data.
AstOleDbDestinationNode
The OLE DB destination loads data into an OLE DB-compliant database that uses a database table, a view, or an SQL command.
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.
AstPercentageSamplingNode
The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input.
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.
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.
AstRecordSetDestinationNode
The Recordset Destination component creates an in-memory ADO recordset that is stored in a variable.
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.
AstScriptComponentDestinationNode
The Script Component Destination type corresponds directly to a SQL Server Integration Services script component with an input buffer.
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.
AstSortNode
The Sort transformation sorts input data in the specified order and then copies the sorted data to an output file.
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.
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.
AstTermExtractionNode
The Term Extraction transformation extracts terms from input text columns and directs the terms to output text columns.
AstTermLookupNode
The Term Lookup transformation extracts terms from input text, places the terms in an input column, and compares these terms to terms in a reference table.
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.