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) 🙂 🙂 🙂
    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