none
Failed to connect to excel connection manager RRS feed

  • Question

  • Hi Gurus,

    I have to load data from excel source to a sql server table. When i tried to create the connection manager i get the following error message. The scenario is as below

    I have SSIS installed on a machine that doesnt have excel.

    I am getting the files from a folder on a shared drive location. The supposed excel file has the .xlsx extensio but has text file icon. When i open  its unreadable format.

    My question is do i need to install excel ?

    I am using MS  SQL Server data tools for Visual studio 2017 SSDT

    The server is windows server 2012r2

    please advice

    TITLE: Microsoft Visual Studio
    ------------------------------

    Could not retrieve the table information for the connection manager 'Excel Connection Manager'.
    Failed to connect to the source using the connection manager 'Excel Connection Manager'

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Wednesday, June 19, 2019 7:01 PM

Answers

All replies