One other thing you might want to try. Use the 'Export Data' function in SSMS to export something from SQL Server to an excel spreadsheet. Be sure to save the package that is auto created.

When you've finished with the wizard, examine the saved package. That will give you an idea of how to build a package to export to excel. You'll want to take a good look at the SQL Task used to create the excel spreadsheet. It's a step that's needed before the data flow so that you have the excel spreadsheet to receive the data.

Added:

You'll also want to check the data flow. You'll find that there is a data conversion that's needed for preparing the data to be handled by excel data types.