To enable explicit pass-through
processing by default for new instances of most SQL transformations,
select
ToolsOptionsJob Editor Tab, and then select
the pass-through check box in the
Automatic Settings area.
This setting affects SQL Join transformations and also any SQL transformation
whose properties window includes a
Database pass-through option
on its
Options tab. This includes SQL transformations
such as Create Table, Insert Rows, Set Operators, Delete, and Update.
To enable pass-through
processing for an SQL Join transformation, open the properties window
for the transformation and specify
Yes in
the
Pass Through property. The SQL Properties
pane also contains the
Target Table is Pass Through property,
which determines whether explicit pass-through is active for the target
table. This property enables the target to have the select rows inserted
into the target within the explicit operation. This property is valid
only when all the tables in the query, including the target, are on
the same database server. The
Target Table is Pass Through property
has a corresponding property, named
Target Table Pass
Through Action. The
Truncate option
in this property is useful for DBMS systems that does not allow the
target to be deleted or created. In this case, the only option is
removing all of the rows. If
Truncate is
selected, all of the rows in the table are deleted. If the table does
not exist, it is created.