SSIS Export to Excel File

Описание к видео 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.

Комментарии

Информация по комментариям в разработке

Похожие видео