Using SQL Server 2000 latest SP and DTS Designer.

I am using a String trim transformation with
-Text file (~ delimited) as data source
-SQL Server table as a destination

Although ticked "Leading" and "Trailing" spaces to be trimmed.

~ ~ (tilda space tilda) is not trimmed, resulting in a space in destination
column.

Problems like that if not answered by a driver setting or functional
method will likely best be handled by changing that columns
transformation into not merely a COPY operation but into an ActiveX
transformation.

i.e. double-tap on black transformation line between sources, then hit
the transformation tab, delete the line connecting the two columns
involved - click-drag to create a new "ActiveX" vs. COPY
transformation.

Alternatively buffer the data into a temporary table and clean it up by
hand; may work depending on size of data involved.



[quoted text, click to view]