dataflow to excel - Convert numbers stored as text to numbers Excel Cell Error RRS feed

  • Question

  • I'm trying to write data to excel from an ssis component to a excel destination.

    Even thought I'm writing numerics, every cell gets this error with a green tag:

    Convert numbers stored as text to numbers

    Excel Cells were all pre-formated to accounting 2 decimal, and if i manually type the exact data Im sending it formats just fine.

    I'm hearing this a common problem -

    On another project I was able to find a workaround for the web based version of excel, by writing this to the top of the file:

    <style>.text { mso-number-format:\@; } </style>

    is there anything I can pre-set in excel (cells are already formated) or write to my file so that numerics are seen as numerics and not text.

    Maybe some setting in my write drivers - using sql servers excel destination.

    So close.. Thanks for any help or information.
    Tuesday, March 27, 2007 8:17 AM