REVERSE (SSIS Expression)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Returns a character expression in reverse order.
Syntax
REVERSE(character_expression)
Arguments
character_expression
Is a character expression to be reversed.
Result Types
DT_WSTR
Remarks
The character_expression argument must have the DT_WSTR data type.
REVERSE returns a null result if character_expression is null.
Expression Examples
This example uses a string literal. The return result is "ekiB niatnuoM".
REVERSE("Mountain Bike")
This example uses a variable. If Name contains Touring Bike, the return result is "ekiB gniruoT".
REVERSE(@Name)