MS SQL Server DTS - Leading Zero Is Dropped

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Leading Zero Is Dropped

WhiskyRomeo

2005-07-28, 9:24 am

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

Sponsored Links