Follow these steps to export data from a table in SQL Server Management Studio to an Excel file:
|Note: Yellow exclamation points imply a concern with the mapping of the data from SQL Server to Excel. Double-click the yellow exclamation point to view a report of the mapping. The mapping can be modified by selecting Back and then selecting Edit Mapping.|
|Note: If you are using the Express version of SQL Server, the only option displayed is Run immediately. If you are using a paid version of SQL Server, you can Run immediately or Save SSIS Package.|
Warning! After selecting Finish to run the job, if Operating stopped is displayed and there is an Error, the export failed. In this scenario, select Messages to view detailed information on what caused the export to fail.
If you created an SSIS Package, follow the instructions in the article on How to run a SQL Server SSIS DTSX package using Windows PowerShell.