SQL 2005 SSIS Excel Source Insert NULL Values for all Records

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Werner Moecke — Thu, 03 Jan 2013 19:03:39 GMT

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.

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Carlos — Wed, 25 Jul 2012 22:32:06 GMT

Great I was having the same problem with SSIS 2008

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

shruthi — Fri, 02 Mar 2012 19:16:07 GMT

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

please post an example.

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Rock — Mon, 31 Oct 2011 20:24:19 GMT

Thanks for this info.

It solves my problem.

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

baba — Thu, 04 Aug 2011 19:06:46 GMT

perfect

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Gilles Renou — Thu, 28 Jul 2011 18:24:53 GMT

You saved my day!

Many thanks

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Congruus — Wed, 12 Jan 2011 16:01:21 GMT

Just perfect, thx.

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Tony P Raju — Thu, 06 Jan 2011 06:22:19 GMT

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

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

vivek — Mon, 29 Nov 2010 07:40:24 GMT

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

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Rajeev — Fri, 23 Jul 2010 16:42:04 GMT

Worked like a charm

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Zeta — Tue, 13 Jul 2010 16:16:29 GMT

Thanks for the solution.

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

me — Tue, 13 Jul 2010 12:34:12 GMT

Thank YOU!

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

SrinivasuluM — Tue, 27 Apr 2010 05:27:47 GMT

Simply superb solution :)

i am struggling with this issue from last two days

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

Thu, 25 Mar 2010 14:32:36 GMT

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

re: SQL 2005 SSIS Excel Source Insert NULL Values for all Records

Oliver — Tue, 01 Dec 2009 18:40:02 GMT

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!