Want integers to go in excel as numbers not text

  • I have a package thats exporting data to an excel file. Its working but for some reason the integer values in the excel file have a warning symbol and says the number is formatted as text. How can I get the inegers values toi the excel file as a number? I have already opened the advanced editor for the excel destination and set the datatype of the columns to integers.

  • Hi

    Set Long data type when you creating table in Excel Destination Editor.

    Br.

    Mike

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

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