SSIS Excel to SQL Server Table
Using SSIS we import an Excel spreadsheet into a new SQL table. The table is created during the SSIS package development.
The "Microsoft Access Engine Redistributable" needs to be installed only if you do not have Office installed. Also, most companies will not install Office on a production server so this is how your server admin can add the objects to your SSIS server.
https://www.dbtales.com
