Post reply

Excel source error in SSIS

  • May 16, 2019 at 2:14 pm

    #3644227

    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

  • May 16, 2019 at 10:25 pm

    #3644388

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

    What error is that, exactly?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • May 17, 2019 at 10:03 am

    #3644475

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

     

  • May 17, 2019 at 10:56 am

    #3644480

    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 3 (of 3 total)

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