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.

[@lyndia9606]

what is the purpose to install ms access redistributed? what if didnt install it ?

[@databasetales3562]

Office objects, like Excel, are usually installed on a workstation because Office apps are already there and licensed (Word, Excel, Powerpoint etc.). The Server does not have Office installed so they provide these objects so you can run the SSIS package on the server and create an Excel file, just like you do on your workstation.