Unable to create an to Excel connection from SSIS in Azure. RRS feed

  • Question

  • Hi All,

    In Azure VM environment, we have Windows 2016 Datacentre ,Microsoft Visual Studio 2016 and SQL Server Data Tools 2015.While trying to make an EXCEL connection via SSIS we are receiving the error as "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. Please help us with a resolution on how we can connect to Excel connection manager in this environment.   

    Thursday, March 2, 2017 6:02 PM

All replies

  • Hi

    You may be missing the excel drivers (ACE), they do not come installed (unless you installed office). You can down load them from here.

    If you intend to develop on this machine then you will need the 32 bit driver as Visual studio is still a 32 bit application. If you develop you package on another machine then the can use the 64 bit driver as SSIS will run in either modes.

    Thursday, March 2, 2017 7:25 PM