Write data into excel sheet from sql server

i want to export data from SQL Server to Excel sheet
The data is coming from different recordsets.

Can use dts to do that.