What is the best way to remove trailing spaces in a dataflow in a SSIS
package?

The SRC OLEDB connection is to a Visual FoxPro DB - all of the columns
in the tables are CHAR so trailing spaces are included in the dataflow.
The DST OLEDB connection is to a SQL database where VARCHAR fields are
defined. I want to RTRIM the trailing spaces when niserting into the
SQL Server tables in the DATAFLOW task.

It seems like a very trivial thing to do, but I can't see anything
rather than writing some ActiveX scripting which seems like a lot of
work.

Thanks in advance!

I ended up using a derived column transform to perform this task with
the expression equal to LTRIM(RTRIM(<column>)).

Pretty simple and effective.

Hello jimdandy (AT) shaw (DOT) ca,

Glad you found it and yes this is the way to go if you cannot do it in the
source statement on the source adapter.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com