SSIS Package

lux sat
lux sat used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Administrator
Top Expert 2005
Commented:
RTRIM(LTRIM([EMAIL-FIELD])) == "" ? NULL(DT_WSTR,1) : RTRIM([EMAIL-FIELD])

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial