You can use the Assign transform to set the value of an output element to a constant or fixed value.
The Assign transform sets a value that can be a fixed value or it can be the result of a function that has no input; for example, a current date function.
You cannot use the value of an input element to set the value of an output element with the Assign transform.
The output element is set to a constant value.
The output element must be a simple type element.
For more information about assigning a value to an output element, see Setting the value of an output element to a simple data type.
You must assign a value in the Value field located in the General tab of the Assign transform properties view.
If you do not specify a value, an empty element is created.
You can define supplement connections between input elements and the Assign transform. You can then use these input elements in a conditional expression that defines the condition under which the transform should be applied. If the condition evaluates to true, the transform is applied.
For more information on how to configure these properties, see Configuring a mapping transform properties.
Type | Default value |
---|---|
string | Empty string |
dateTime | 2002-01-01T11:00:00 |
boolean | false |
decimal | 0.0 |
double | 0.0 |
hexBinary | 00 |
long | 0 |
duration | P1Y |
time | 00:00:00 |
date | 2002-01-01 |