SSIS: loading data from Excel source

Hi, I am loading data from Excel using Import data wizard. I also saved it as SSIS package.
However the problem is that last Excel column data is not loaded in the database table. This column has NULL values in all rows. Columnmapping is correct.
Any ideas?
quasar_eeAsked:
Who is Participating?
 
Koen Van WielinkConnect With a Mentor Business Intelligence SpecialistCommented:
Is it loading the remaining data in the other columns correctly? Are you sure the data in your Excel file is NULL and not a blank? Could you attach a sample file?
By the way, if the column contains only NULL values, why not just set the default column value in SQL to NULL and ignore the column during import?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.