Trim Functions in SSIS
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In fact, a good number of the commonly used functions from T-SQL are in SSIS as well. Here we will explore the different Trim functions found in SSIS.
We will be using the test phrase ” Test ” to illustrate the three functions: LTRIM, RTRIM and TRIM.
LTRIM (Left Trim):
Just as in T-SQL, this removed empty spaces from the beginning (or left) of a string.
Notice the highlighted result that the trailing spaces are still present but the leading spaces are gone.
RTRIM (Right Trim):
Just as in T-SQL, this removed empty spaces from the end (or right) of a string.
Notice the highlighted result that the trailing spaces are gone but the leading spaces are still present.
In T-SQL to remove both leading and training spaces you have to nest the trim statements like this: SELECT LTRIM(RTRIM(ColumnName)) AS ColumnName FROM Table. Luckily in SSIS there is a TRIM function that will remove both leading and trailing space in one function called TRIM.
Notice the highlighted result that the trailing and leading spaces are gone.