Link to home
Start Free TrialLog in
Avatar of lux sat
lux sat

asked on

SSIS Package

My data load from fixed width file to SQL seems to having spaces at the end of text.

I have the following in the derived column
RTRIM(LTRIM([EMAIL-FIELD])) == "" ? NULL(DT_WSTR,1) : [EMAIL-FIELD]

What should I be doing to remove extra spaces at the end of text.
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial