In SQL Server 2005 we use a File System Task to creat the excel file, then an OLE DB datasource to feed the results of our query to an Excel Destination object. This method should work in 2008, but I haven't tested it.

Forgot one piece of info, we have a blank excel template setup that we copy with the file system object, this way all of the field names are setup.