How do I export numeric fields into a test file that the
numeric fields are right-justified(the default is left-
justified).

Thanks.

In article <011701c35d0a$f3712300$a401280a (AT) phx (DOT) gbl>, Jian Liu
<Jizliu (AT) hotmail (DOT) com> writes
You could use a source SQL statement, convert the field to varchar and
pad with spaces up to the field length.

Or

Use an ActiveX Script Transform where you could follow the same process.

SQL would probably be faster.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com