Suppose you are loading data under these conditions:
The source database has contact
first name, contact last name and company name fields. A target database
has a company table and a contact table.
You need to insert source contact
data into the target contact table, and the source company data into the
target company table.
Create two target steps:
One step for the contact record insert.
One step for the company
record insert.
The sequence of steps is repeated for each source row. Steps are executed
in the order that they are displayed.
Step 1
First name and last name data
values are obtained from the first source row.
Lookup links and data links
are read to determine the destination for the data in the target database.
Formulas to reformat the data
are applied, as defined in the DTS file.
A SQL transaction is created
that will be applied to the target database.
Step 2
The company name data value
is obtained from the first source row.
Lookup links and data links
are read to determine the destination for the data in the target database.
Formulas to reformat the data
are applied, as defined in the DTS file.
A SQL transaction is created
that will be applied to the target database.
This sequence of steps is repeated for each source row. Steps are executed
in the order that they are displayed.
Note: A single data object in the target can be
added more than once as multiple steps. This is necessary when the target
is more normalized than the source.