Post reply

Not reading/ pulling data correctly from XLS data source

  • January 14, 2010 at 6:07 am

    #141611

    Hi,

    I hope someone can help.

    I am creating a SSIS package data source is a XLS file that has a column with date, number, text etc so its a general data type. The data is not pulled correctly from the XLS file e.g. value 17,000 is reading as "7. Why is this?

    Any ideas/ help will be appreciated.

    Thanks

  • January 14, 2010 at 6:59 am

    #1103568

    Good old Excel. First place to start might be with IMEX=1 in your connection string. See here for more info.

    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

  • January 14, 2010 at 7:19 am

    #1103578

    Can you send me the full connection string example please? I didn't get the link for more info?

  • January 14, 2010 at 9:18 am

    #1103703

    The word 'here' in my previous post is a hyperlink.

    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

  • January 14, 2010 at 9:22 am

    #1103709

    Ok thanks. I did get this working thank you

Viewing 5 posts - 1 through 4 (of 4 total)

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