• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 657
  • Last Modified:

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?
0
quasar_ee
Asked:
quasar_ee
1 Solution
 
Koen Van WielinkBusiness 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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now