Not reading/ pulling data correctly from XLS data source

  • 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

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


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

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


  • Ok thanks. I did get this working thank you

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

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