Post reply

Extract data from Excel Sheet Using SSIS Package

  • February 6, 2009 at 11:50 am

    #127440

    Hi Friends,

    I am trying to Extract the data from Excel Sheet to SQL Server

    I have some fields in One column Like 3+ its showing Null in destination.

    One more thing I have Some fields in One column like Associate's, Master's but its showing Null in SQL table

    I think its not reading from Excel for such formats

    can you please tell me the process to Extract such data

    Is there any transformation for this issue?

    Thanks in Advance

    kala

  • February 6, 2009 at 7:44 pm

    #939883

    Could it be that the columns are being interpreted as numeric (because the first few rows of data contain numbers in those columns)? If so, when the non-numeric data is encountered, it will be skipped.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply