May 16, 2019 at 2:14 pm
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
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
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
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