Workflow Basics Guide

10.4.0
- 10.5

Back Next

Defining the Treat Source Rows As Property

When the Integration Service reads a source, it marks each row with an indicator to specify which operation to perform when the row reaches the target. You can define how the Integration Service marks each row using the Treat Source Rows As property in the General Options settings on the Properties tab.

The following table describes the options you can choose for the Treat Source Rows As property:

Treat Source Rows As Option	Description
Insert	Integration Service marks all rows to insert into the target.
Delete	Integration Service marks all rows to delete from the target.
Update	Integration Service marks all rows to update the target. You can further define the update operation in the target options.
Data Driven	Integration Service uses the Update Strategy transformations in the mapping to determine the operation on a row-by-row basis. You define the update operation in the target options. If the mapping contains an Update Strategy transformation, this option defaults to Data Driven. You can also use this option when the mapping contains Custom transformations configured to set the update strategy.

After you determine how to treat all rows in the session, you also need to set update strategy options for individual targets.

Rename Saved Search

Table of Contents

Workflow Basics Guide

Workflow Basics Guide

Defining the Treat Source Rows As Property

Defining the Treat Source Rows As Property