cannot importing excel file with leading zeros in zip+4

[avid1741]

I am trying to import an excel file with zip+4 data that includes leading zeros. When I import using DTS the leading zeros are dropped. Is there a way to do this and keep the leading zeros?

 

[rtgordon]

I had trouble with this, too. The single quote was not working... My DTS package counted anything with a leading zero null. My approach was to append a character (i.e. X) to the front of all values in the column then strip off the x when I moved it from a temporary table to the permanent table with this code:

SET @SizeOfPart = Right(@SizeOfPart, Len(@SizeOfPart)-1)

Good Luck!