Getting nulls when loading Excel data using SSIS
The first thing you should do, is take a deep breath. Good. Now Grrrr. &/&/¤%"¤%! SSIS/Excel gotcha!
The thing is:
you want to use SSIS to load data from an excel file AND
you have a column where the first 8 rows are null AND
the Excel datatype for the Column is set to Standard
then SSIS will load all values as null.
No worries, just do as follows:
1) Make sure that the excel file has the correct datatype on the column header when you create the SSIS package.
2) insert IMEX=1 in the connection string on the Excel connection manager.
This drove me insane. On many levels.
Read more at