Selects multiple sets
of rows from a source and writes those rows to a target. Typically
used to create one subset from a source. Can also be used to create
columns in a target that are derived from columns in a source. For
more information, see Extracting Data from a Source Table.
|
|
Provides a simple SQL
interface for inserting rows into a target table. For more information,
see Inserting Rows into a Target Table.
|
|
Enables you to use set
operators to combine the results of table-based queries. For more
information, see Using the SQL Set Operators Transformation.
|
|