Leading Zero Is Dropped
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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
.
Relevant Pages
- Re: Scheduling an Excel Print Job
... is the last step in my DTS package after creating the extract. ... so the batch program will only run when the PC is started up. ... >>I have an SQL DTS package that extracts data to an Excel spreadsheet. ...
(microsoft.public.excel.printing) - Re: Timeout on a task?
... loss. ... > We're using VB6 to use Automation to write a DTS package in memory, ... with SQL Server 2000 as the destination. ... > For smaller feeds that process faster, ...
(microsoft.public.sqlserver.dts) - RE: Resultat in eine Textdatei speichern
... Destination wählen ... Nun hast du ein DTS Package, ... hier hinein das gleiche SQL von der Prozedur genommen. ...
(microsoft.public.de.sqlserver) - Re: How do I dynamically change output text file properties?
... The procedures extract the data and I can individually create a DTS package ... of a destination source when that source is a SQL Server table, ... You can use a dynamic properties task to browse a text file ...
(microsoft.public.sqlserver.dts) - sql server freezes excel
... I'm using sql server's DTS to import an excel spreadsheet. ... again - until I use the DTS package when the problem repeats itself. ...
(microsoft.public.excel.misc) |
|
