Explanation/Reference:
Explanation:
XLSX files, the new file type in Excel2007/2010 cannot be opened with Excel Source/Destination in SSIS.
To use XLSX in SSIS we need to install ACE driver and use OLE DB Source/Destination to read read/write data in XLSX files.
ACE is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel 7 (*.xls, *.xlsx, and *.xlsb) files to Microsoft SQL Server. If the SQL Server or your development box does not have ACE driver then install that 1st.
Note:
* The most efficient way to link to SQL Server is using an OLEDB connection manager.
References: https://docs.microsoft.com/en-us/sql/integration-services/connection-manager/connect-to-an- excel-workbook