excel preview showing integer values null in a alphanumeric column

  • Hi,

    When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview.

    The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.

    Is there any solution to this problem ? Please help it is creating a lot of problems for me.

    Also provide alternative solutions if this cannot be worked out.

    Thanks for the help.

    Shobhit Bansal

  • hi.shobhit76 (6/25/2009)


    Hi,

    When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview.

    The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.

    Is there any solution to this problem ? Please help it is creating a lot of problems for me.

    Also provide alternative solutions if this cannot be worked out.

    Thanks for the help.

    Shobhit Bansal

    This is well known issue with the Jet Excel driver. Check this discussion for possible resolutions.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • hi CozyRoc,

    I did what has been told in the discussion which you forwarded to me but that didn't solve my problem.

    I am using Microsoft Office Excel 2003 (11.5612.5606) , And i am using SSIS not DTS ,

    Please help !!!!

    Thanks

    Shobhit

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

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