Inserting a script execution

Chapter 10 Building Data Transformation Diagrams

Inserting a script execution

A script execution represents the execution of a script for each row of the incoming flow.

You have to type a script language for the script execution and define a script expression in the Script tab. Data from the incoming flow may be used as parameter.

In the case of a complex expression, such as the combination of multiple sources, you need to edit the data structure columns in order to add sources and modify the source expression.

You can modify the data structure columns of a script execution.

To insert a script execution:

Select the Script Execution tool in the palette, and create the corresponding object in the diagram.

Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the script execution to initialize it with the appropriate columns.

Double-click the script execution symbol to open its property sheet. The Data Structure Columns tab is automatically completed with the values from the incoming flow.

Click the Data Structure Columns tab and do any appropriate changes.

Click the Script tab, type a script language from the Script Language list, and type a script expression in the textbox.

Click OK to save your changes and return to the diagram.