Solved

SSIS: loading data from Excel source

Posted on 2014-03-25
1
622 Views
Last Modified: 2016-02-10
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
Comment
Question by:quasar_ee
1 Comment
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 500 total points
ID: 39955041
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question