Post reply

Export plain-text file

  • August 11, 2003 at 1:45 pm

    #64656

    Hi,

    I have a problem when exporting a single table from SQL 2000 to plain-text file. The tool is DTS, and the decimal symbol is written as . (dot) instead , in smallint datatype type.

    How can I to export the data in the same format that the table.

    Thanks

  • August 12, 2003 at 12:42 am

    #469500

    Hi marcospaz60,

    quote:

    I have a problem when exporting a single table from SQL 2000 to plain-text file. The tool is DTS, and the decimal symbol is written as . (dot) instead , in smallint datatype type.

    How can I to export the data in the same format that the table.

    ahem, maybe I am missing something, but why do you want to export a smallint data type with decimals anyway. Integers are discrete values like 1,2,3 and nothing in between.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply