How to Remove Leading/Trailing Spaces of NText datatype Text
Posted on 2006-05-04
I am using DTS to import data from one table to another. But I want the 2nd table to contain the same text minus the leading/trailing spaces of the text from the first table. The fields have datatype NTEXT. RTrim/LTrim doesn't seem to work. What's the trick?
Here's my Transformation Script:
DTSDestination("TempText") = vbcrlf & RTrim(DTSSource("temp_text"))
Main = DTSTransformStat_OK