Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.
MakeDateTime
Description
Creates a date based on the parameters passed into the function.
Aggregation that returns max date the group. Can only be used as part of the Advanced Aggregation component
Syntax
Max( Value [, Condition])
Returns
Date.
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Max(SalesDate, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.
Aggregation that returns max number the group. Can only be used as part of the Advanced Aggregation component
Syntax
Max( Value [, Condition])
Returns
Integer.
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Max(SalesTotal, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.
Aggregation that returns max string the group. The value is based on the ascii value of the string. Can only be used as part of the Advanced Aggregation component
Syntax
Max( Value [, Condition])
Returns
String
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Max(CustomerAlternateKey, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.
Calculates the checksum of the input value. The function uses Message-Digest algorithm 5 (MD5). MD5 is a one- way cryptographic hash function with a 128-bit hash value. You can conclude that input values are different when the checksums of the input values are different. Use MD5 to verify data integrity.
Syntax
MD5( Value )
Returns
Unique 32-character string of hexadecimal digits 0-9 and a-f. NULL if the input is a null value.
Parameters
Name
Optional
Description
Value
false
String or Binary datatype. Value for which you want to calculate checksum. The case of the input value affects the return value. For example, MD5(ssis) and MD5(SSIS) return different values.
Examples
MD5("secure this")
MessageBox
Description
Displays a MessageBox with a message (Only works in BIDS / SQL Server Data Tools). Used for debugging purposes during design time.
Syntax
MessageBox(Message [, Condition])
Returns
Nothing
Parameters
Name
Optional
Description
Message
false
The message to display.
Condition
true
The condition to evaluate to true before display the MessageBox
Examples
MessageBox("This is a message"), MessageBox("Values didn't match", value1!=value2)]
Aggregation that returns Min date the group. Can only be used as part of the Advanced Aggregation component
Syntax
Min( Value [, Condition])
Returns
Date.
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Min(SalesDate, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.
Aggregation that returns Min number the group. Can only be used as part of the Advanced Aggregation component
Syntax
Min( Value [, Condition])
Returns
Integer.
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Min(SalesTotal, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.
Aggregation that returns Min string the group. The value is based on the ascii value of the string. Can only be used as part of the Advanced Aggregation component
Syntax
Min( Value [, Condition])
Returns
String
Parameters
Name
Optional
Description
Value
false
The value to add to the aggregation
Condition
false
The condition allows you to conditionally add values to the aggregation based on the expression. For instance, you could define the aggregate as Min(CustomerAlternateKey, CustomerState="FL") and this would only add the value to the aggregation if the customers state was florida.