SSIS Export to Excel File
SSIS tutorial on exporting a SQL query result to an Excel spreadsheet. This example does not require Office to be installed but we use the Office Objects instead. We create a new spreadsheet and load a worksheet with data from a SQL Server query.
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.
