Documentation

Biml API Reference
AstTransformationNode.CanAutoLayoutMoveSourceAnchors Property
BimlStudio 2017

Gets a value to indicate whether autolayout is permitted to rearrange source anchors on the design surface to reduce edge overlapping
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:
False
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.
AstContactVerifyNode
The Melissa Data Contact Verify custom component is used to detect suspicious values, standardize, normalize, verify, correct, or supplement various properties of contact information, including names, addresses, geocoding, phone numbers, and email addresses. It uses a local or remote database that is regularly updated with the latest data from the U.S. and Canada. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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.
AstDataMiningModelTrainingNode
The Data Mining Model Training destination is used to train data models in an Analysis Services cube.
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).
AstDimensionProcessingNode
The Dimension Processing destination loads and processes an SQL Server Analysis Services dimension.
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.
AstFuzzyMatchNode
The Melissa Data Fuzzy Match custom component provides a robust, highly configurable collection of options to perform fuzzy matching on any selected input data fields. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
AstGlobalVerifyNode
The Melissa Data Global Verify custom component is used to verify, correct, and supplement various properties of contact information across more than 240 countries, ensuring that address records are correct and complete. It uses a local or remote database that is regularly updated with the latest international data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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.
AstMatchUpNode
The Melissa Data Match Up custom component is used to identify duplicate contact records. Even when contact properties are not exact matches, the component uses fuzzy matching and a variety of scoring algorithms to identify matches. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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.
AstMultipleHashNode
The Multiple Hash custom component is used to produce hash values for a selection of input columns using a choice of hashing algorithms. It is capable of producing multiple hashed output columns with a single instance of the component. You will need to install this component on your server as it is published on CodePlex as a community project. Please see http://ssismhash.codeplex.com for more information.
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.
AstPartitionProcessingDestinationNode
The Partition Processing destination loads and processes a SQL Server Analysis Services partition.
AstPercentageSamplingNode
The Percentage Sample transformation generates a sample data set by randomly selecting a specified percentage of data flow rows from the input.
AstPersonatorNode
The Melissa Data Personator custom component is used to verify, correct, and supplement various properties of contact information, ensuring that records are correct and complete. It uses a local or remote database that is regularly updated with the latest international data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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.
AstSmartMoverNode
The Melissa Data Smart Mover custom component is used to identify contacts who have reloacted and automatically update their contact information. It uses a local or remote database that is regularly updated with the latest U.S. data. You will need to install this component on your server as it is published by Melissa Data. Please see http://www.melissadata.com/data-quality-ssis for more information.
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).
AstSqlServerCompactDestinationNode
The SQL Server Compact destination writes data to SQL Server Compact databases.
AstSqlServerDestinationNode
The SQL Server destination bulk loads data into SQL Server tables and views.
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.