Excel source error in SSIS

  • a2zwd

    SSCrazy

    Points: 2342

    Hi

    I have visual studio 2017. I am trying to import excel file.

    Copied Excel source and selected the excel file on local machine. But, it is not showing excel workbooks(table list)

    I have Office 365 installed. I tried Run in 64 bit runtime to False still same error.

    I tried to download Office 2016 redistributable. I am getting error "Already has 64 bit office installed. Remove first..."

    What is the issue? How can I get my ssis package succeed?

    Thanks

  • Phil Parkin

    SSC Guru

    Points: 243263

    I tried Run in 64 bit runtime to False still same error.

    What error is that, exactly?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • a2zwd

    SSCrazy

    Points: 2342

    Actually the error is "Could not load table information" So, in the Excel source, table dropdown, no tables displayed.

     

  • a2zwd

    SSCrazy

    Points: 2342

    Hi,

    Issue fixed. I have installed Office 2010 redistributable 32 bit at command prompt with /passive switch

    Working now

    Thanks

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

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