Add ETL Control ID

Add ETL Control ID creates new derived columns called:

• ETLCONTROLID using the expression, @[User::ETLControlID]
• SOURCEDIMID using the expression, @[User::SourceDimID]

There are two editors for this data flow component. To access the editors for Add ETL Control ID, double-click the Add ETL Control ID data flow component or highlight the component and click Show Advanced Editor or Show Editor. From the Derived Column Transformation Editor (Show Editor), you can develop the transformation through drag-and-drop or double-clicks.

You can also edit the transformation through the Advanced Editor using properties.

For more information about Derived column transformations, see Microsoft's MSDN article at Derived Column Transformation.