Export to Excel : Numbers as Text problem

• anuragingle

  SSChasing Mays

  Points: 652

  More actions

  September 22, 2010 at 10:16 am

  #238584

  I have created a SSIS package with the following tasks

  a. Script Task to create Dynamic Filename with current date

  b. SQL Task to create a worksheet in the excel 2007 file

  c. Dataflow task with oledb destination to pump data from table to the created worksheet in the xlsx file

  The package works fine but my problem is that the numbers in the excel sheet are formatted as text and have that green wedge and warning

  Any way to get save the numbers as numbers in the excel worksheet from inside SSIS?

  Thanks

• PaVeRa22

  SSCommitted

  Points: 1965

  More actions

  September 22, 2010 at 11:37 am

  #1225797

  you have to use excel interop name space to interact with excel and change the text to number format,

  or

  use activeX script task to change the text to number format by setting formatnumber of that cells,