Post reply

SSIS Data Flow to Excel think my Number is Text

  • June 17, 2014 at 5:33 am

    #286667

    Hi,

    I am exporting Data to Excel using SSIS, but while exporting it Convert Numbers Stored As Text To Numbers Excel Cell Error,

    every cell gets this error with a green tag.

    Can you please guide me how can I export my int value and number in Excel.

    Thanks

  • June 17, 2014 at 2:08 pm

    #1722507

    You need to pre-format an Excel file with the correct format, and then use it as the destination file. Maintain a copy of the formatted, but empty file, and copy it into the destination folder as part of a script step that precedes your output step. Also, be sure to adjust the mapping to the spreadsheet to be sure it sees the fields as the correct format.

    Steve?(aka sgmunson)?:) 🙂 :)?
    Health & Nutrition
    Rent Servers for Income (picks and shovels strategy)

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

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