SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Thanks a lot for the help.

I ran into a similar problem and I was preparing to give up when I ran into this post. IMEX=1 solves the problem regardless of the data type SSIS chooses.

Thanks for the information.

I have another problem.In SSIS i am not able to open a xlsx file using Excel Source.

Can anyone help me please how to do this.

Thanks.........

Simply superb solution :)

A user provided spreadsheet contained numbers that should be considered as text (ex. 001230).  When loading the data to SSIS some numbers were converted to NULL even though in the spreadsheet there is a value (ex. 12333).  I tried formatting the entire column to TEXT and even copying the values to another column that was pre-formatted to TEXT but it did not solve the problem.  I had to paste the entire column fist to Notepad and then paste them back to Excel.  That worked.

However, your solution saved me the trouble of trying to fix the Excel spreadsheet.

Thanks a lot for sharing!

Pingback from  Kasper de Jonge BI Blog » Import Excel in SSIS and get Null values in stead of Numeric values

Simply superb solution :)

i am struggling with this issue from last two days

Thank YOU!

Thanks for the solution.

Worked like a charm

Thanks a lot your solution has saved a lot of time .............thanks for sharing ..............great JOb ....... :)

I did it in SSIS 64 bit. It is working Properly

Just perfect, thx.

You saved my day!

Many thanks

perfect

Thanks for this info.

It solves my problem.

please tell me where to add the above string in connection string

please post an example.

Great I was having the same problem with SSIS 2008

Actually, I found that you need to perform BOTH steps suggested by MS, otherwise just either one alone won't cut it.

To summarize:

You *NEED* to include the "IMEX=1" parameter in the extended properties in the connection string AND move a couple lines with chars to the beginning rows of the excel spreadsheet.