This topic describes how to configure the transformation components supported by the extract, transform, and load (ETL) feature of Data Transmission Service (DTS).
Background information
The ETL feature supports the following transformation components:
- JOIN
- Field Calculator
- Table Record Filter
Limits
The transformation components supported by the ETL feature have the following limits:
- JOIN: You can perform JOIN operations only between two tables.
- Field Calculator and Table Record Filter: Only a single table schema is supported.
Prerequisites
A source database is configured.
Configure the JOIN component
Configure the Field Calculator component
Configure the Table Record Filter component
Result
