I have a DTS package that reads data from SQL-Server and exports it to
a file using a TextFile connection. When I export numbers using the
Copy Column transformation I get leading spaces instead of zeroes. I
can solve this by using the ActiveX script transformation instead but
should I really have to do this?

So you must be holding the numbers in SQL Server as a string then to
have the leading 0s

Are you using a fixed Width file or delimited?

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"stefanjohansson_2005@yahoo.se" <stefanjohansson_2005@yahoo.se> wrote in
message news:1167743575.102054.143240@n51g2000cwc.googlegroups.com:

[quoted text, click to view]