Reading from an Excel file into SSIS

  • Hi

    I have an excel file which i am reading through SSIS through MICROSOFT Office 12.0 Access Database Engine OLE DB Provider. My problem is that if the Excel file has data in a column as 123.45 which is displayed as 123. SSIS is able to pick 123 only and not 123.45. however if I change the data type to Numeric in the excel, SSIS is able to read data as 123.45. Any solution other than changing data type in Excel

    Many thanks in advance

  • Hi,

    You have to change the DataType property of Excel Columns using Advance Editor and the excel source reads first eight rows.

    The below article will guide you.

    "https://www.simple-talk.com/sql/ssis/importing-excel-data-into-sql-server-via-ssis-questions-you-were-too-shy-to-ask/#second"

  • That does not work. It takes it as 123 at the source while reading

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

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