Exporting mixed data types to CSV from SQL server 2000 DTS

Hi
I am exporting data from SQL server 2000 table to a CSV file using DTS.
One column in particular is giving an issue.

It is a serial number column - it can have mixed data types - eg; numeric and alpha-numeric.
This does not cause an issue in SQL, the problem is when I export to CSV file format.

The problem is that when the end-user opens the CSV file, the numeric serial number values are observed in scientific notation, so serial number "3554722212705" gets observed as
"3.55472E+12".

When the end-user imports into their system, the serial number gets imported as "observed" in Excel,
ie; it gets imported in "scientific notation" format, with the last few characters of the serial number being zeroes, so serial number "3554722212705" gets loaded into their system as
something like "3.5547200000".

The format of the serial number field when I open the CSV file in Excel is "General"
When I format the field as a number, then the serial number gets observed correctly.

How can I export this column to CSV file so that it does nor result in being treated in
"scientific notation" format ??

thank

FergalStart Free Trial