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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.