Post reply

Excel Source unable to read alphanumeric values.

  • August 12, 2013 at 2:19 pm

    #296909

    I'm creating a simple source--Destination Excel load from a an excel file to SQL server Table using SSIS

    One of the column getting nulls where the data is alphanumeric.

    Example:

    Source Destination

    Col A -----> Col A nvarchar(255)

    12321 ------> 12321

    1D2DE34 -----> NULL -- Here is the issue

    I have tried loading it to a flat file destination and the it is sending null values where there is alphanumeric, from this I understood there is no issue on SQL server side but the excel source was not reading the alpha numeric values from the Excel.

    The excel column format is TEXT

    Do anyone have seen this issue before, ? Please advise.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • August 12, 2013 at 2:47 pm

    #1640708

    This article has all the answers:

    What’s the deal with Excel & SSIS?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 12, 2013 at 8:51 pm

    #1640765

    That is kind of direct route to the issue ..fixed.

    Thank you..Great Article.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

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

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