I have a DTS package that has an Excel spreadsheet as the source and SQL
Server database table as the destination.
Some zip codes have leading zeros but when using a simple Copy Column
transformation the leading zero is dropped. Both source and destination
fields are defined as string (text for Excel and varchar for SQLServer).

In DTS the datatype is 130 which I guess stands of DBTYPE_WSTR changing this
129 which is DBTYPE_STR doesn't help.

WR