Data from oracle to Excel - data showing in excel as scientific notation...

• basam nath

  SSC Journeyman

  Points: 80

  More actions

  June 1, 2009 at 11:14 am

  #205380

  I need help folks.

  I have a simple data flow task which has a OLE DB data source,

  Data conversion and OLE DB destination.

  The OLE DB data source is pointing to an oracle table.

  The OLE DB destination is an excel spreadsheet.

  The data in oracle column is like 0.08245. Unfortunately, it shows up as in scientific

  notation format on the excel column. I want it to show up exactly like in

  data base which is 0.08245.

  I don't know what to do with this issue.

  Any suggestions are greatly appreciated.

  thanks

  nath

• zbleslav

  SSC Enthusiast

  Points: 140

  More actions

  June 2, 2009 at 1:56 am

  #1003213

  Hi,

  "Excel Destination" takes format from last row used. Preformating is possible using templates.

  Little example here:

  http://msbiblog.spaces.live.com/blog/cns!3738F9E9EADAAE6A!148.entry