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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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