I have a DTS package that has 3 fields for the phone number. In SQL they are smallints and when they come over in the .csv file the leading zeros are dropped. I have tried to change them to chars when I do the DTS export, but the zeros are still missing. Is there any way to keep the zeros in the csv file?