excel source reading entire column as nulls

Posted on 2012-08-24
Last Modified: 2012-09-11
i have one excel data feed it contains nealy 20 columns (data may be 4000 records)

few columns having the balcks from the hedders(i.e from starting to 20 records  are blancks),
after some records these colums having the values

when we try to lod the data from excel to DB these entires columns data comming as null even few records have the values

i observed that if i give some value after the hedder then the packge  loadingperfectly

how can i over come this issue if the columns desont have the values from hedder
Question by:parpaa
    1 Comment
    LVL 11

    Accepted Solution

    I've been importing data into SQL Server for years and can tell you Excel is a miserable way to acquire data. If there's any other option, like delimited text, you'll be better off.

    Generally speaking, having nulls or blanks in the first row can cause various import tools, whether the SSMS Import Wizard or the SSIS package designer, to associate the wrong datatype for the column. This happens when you allow the designer to automatically generate the column definitions.

    The solution is to dig deeper into the import source column definition and fix the data type.

    You can also save the Excel file as a .CSV file and import that instead. Usually is much cleaner.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    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.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now