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'



    Wednesday, June 19, 2019 7:01 PM


All replies