Selected my Excel file (Noted that the Excel version changed from 97-2003 to 2007-2010 after I selected the file). . . Follow the steps below to save Excel Online connection properties in a connection manager. . .
Ssis excel connection manager office 365
· Failed to connect to the source using the connection manager 'Excel. To add an SMTP connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection. . . . 0 Access Database Engine OLD DB Provider with Extended properties: Excel 12.