Question: how to export sql data to excel in ssis?
Answer: Create an SSIS package and create ADO.NET connection manager.
Create data flow task that has ADO.NET source to populate data from SQL Server. ... 
Execute SSIS package and verify that data was written to excel and text files.