Want integers to go in excel as numbers not text

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  September 29, 2015 at 3:03 pm

  #321625

  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.

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  September 30, 2015 at 7:09 am

  #1830401

  Hi

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

  Br.

  Mike