Convert Int to varchar in DTS
Convert Int to varchar in DTS
(OP)
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
RE: Convert Int to varchar in DTS
Under the Transform Data Task Properties window, make sure that the field has a Type of "Quotable".
soi là, soi carré
RE: Convert Int to varchar in DTS