Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sundevilscott
Starting Member
12 Posts |
 Posted - 2010-07-16 : 15:30:25
|
| I have an SSIS package that contains account numbers and I pad it with zeros on the left to make it 10 characters.Ex. 10001 changes to 0000010001When I try to spit that out to a flat file it strips the leading zeros. I tried converting it to a Varchar(10) but it still strips out the zeros. In the connection manager I changed the column to string still without luck.Any help would be great. |
|
|
|
|
|
Characters not exporting to Flat File