how to Extract SQL Query result to Excel sheet in SQL server

Question

H, how to Extract SQL Query result to Excel sheet in SQL server, query runns every day its scheduled, so I need to keep all my query result in Excel sheet, Later I will do FTP. Please suggest me is there any way to do in SQL Server. Note :- Not using Result to File in Management studio, I need to know using any scripts in Sql Example - Select * from temp --> result should go to Excelsheet

Kumar AU · Answer

Hi Nirav, Thanks for your response, I am suppose to do this task without using SSIS/DTS Package

Nirav Daraniya · Answer

Hi, You have to use SQL Server Data Tools and make SSIS package for export data from SQL table to Excel sheet , and then create one job which is run this SSIS package at every day (you scheduled time). Nirav Daraniya