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.

[lyndia]

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