Datasheet

Figure 1-8: Derived Column Transformation Editor

In both of these columns, the

== TRUE snippet of code is optional, but is useful for full self-documentation

of code. If you were to have the statement

ISNULL([ModelName]), it would essentially mean the

same thing as this code. Also note that the columns and variables in the expression language are all

case-sensitive.

Your final screen should look like Figure 1-8. Click OK to exit the editor.

Lastly, you want to audit how many rows you are about to write to the flat file. To do this, you can drag

the Row Count transform onto the design pane. Connect the transform downstream of the Derived

Column transform. Rename the Row Count transform to Count Inserts and double-click it to configure

the transform.

Set the

VariableName property in the Component Properties tab to RowCount. The variable name is case-

sensitive. Because the last row is written through the transform, it is counted and logged to the variable

for future use. A typical use for this transform is to count the number of rows transformed and write the

result into an audit table.

With the data now transformed, you’re ready to write the data to the extract file for use by another

party (such as a business partner or another department). Drag over a Flat File Destination and rename

Chapter 1: Getting Started

04_134115 ch01.qxp 4/24/07 6:40 PM Page 13