Documentation

Biml API Reference
AstTransformationNode.ValidateExternalMetadata Property
BimlStudio 2017

This value specifies whether the data flow transformation is validated against columns that originated in external data sources. When server assets such as tables and stored procedures are created during processing, ValidateExternalMetadata is normally set to False, which prevents validation from completing at compile time.
Assembly:
Biml (in Biml.dll)
Language Element:
AstTransformationNode is an abstract type, so it does not have a corresponding Biml language element.
.NET API Metadata
Code Type:
Default Value:
true
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.
AstAdoNetSourceNode
The ADO.NET Source reads data from 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.
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.
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.
AstCustomComponentNode
The Custom Component transformation represents a custom component in SSIS.
AstCustomComponentSourceNode
Defines a custom source component.
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.
AstExcelSourceNode
The Excel source extracts data from 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.
AstFlatFileSourceNode
The Flat File Source reads data from 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.
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.
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.
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.
AstOleDbSourceNode
The OleDbSource reads a data source using one of the OLEDB adapters available on the host system.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.