I have a DTS package that has integer values which I want to convert to chars because they are dropping the leading zeros in the export.  I have search for information on this and I tried adding a convert or cast into the select statement but no matter what I do the leading zeros are still gone.  Does anyone know of anyway to export a file in DTS to a csv file and keep the leading zeros?  From what I read converting it to a varchar/char should work, but it is not working for me.  When I go through the export process and put in the select statement and then look at the mappings under Transform, I see the fields and they say they are char, but when I open the output the zeros are gone.

Any help would be appreciated, this is driving me nuts