using DTS to download data into a file

• Alee-235113

  Grasshopper

  Points: 18

  More actions

  December 7, 2006 at 12:55 pm

  #170648

  I've created a simple DTS package to download data in a table to a file.   In my table, I have a few float columns, and some of the data looks like "3.0456789e-2".  When I run the package, I get exactly that in my text file - "3.0456789e-2", when I really want "0.030456789". 

  Am I doing something wrong?

• Russel Loski

  SSCertifiable

  Points: 7054

  More actions

  December 7, 2006 at 1:01 pm

  #676725

  You need to cast the floats as decimals:  convert(decimal(18,9),mycol).  Use a sql query for the source.

  Russel Loski, MCSE Business Intelligence, Data Platform