November 17, 2014 at 9:19 pm
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
November 17, 2014 at 9:36 pm
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"
November 18, 2014 at 1:47 am
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