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
Any help would be appreciated, this is driving me nuts