I've got a few Transform Data Tasks in a DTS package that run queries to move
data from a production DB to an OLAP staging DB. If it run the query directly
against the data using QA, no extra characters are apparent. After I run the
DTS package, there are one or more "squares" at the end of the text in the
varchar columns.

So, there are no "squares" in the source data, but there are in the target
table (which is truncated before each refresh).

Any ideas on how to prevent this?

TIA,

Mike