SSIS Package from Sql --> Flat File ---> Excel

[azziuhc]

SSIS:

I am using SSIS package to get sql to an excel file output.
The operation failed due to the character string between sql and excel.
However I was able to use the import export utility to execute sql to flat file which works beautiful.
So I am trying to get Ascii to excel.
SSIS: SQl --> Excel (Failed operation due to unicode...)
So I am trying to do the following:
SSIS: SQL --> Flat file (Works ok)

I need to do:
SSIS: SQl --> Flat File --> Excel (???)

Please advice
thank you
Dre

 

[JerryKlmns]

I think excel can handle a .csv file, quite well if it isn't too large.

 

[azziuhc]

I was able to figure it out.
Defining alias fields turnout to be quite a challenge.
I had about 210 fields to export to excel. And everytime I was exporting via Import/Export Wizards it will fail.
I found out that fields cannot have '?' as well as 'DOB' and one strange Field that you cannot have is space in front of singel quote
select a as 'name defined ' would give me an error exporting to excel
BUT
select a as 'Name defined' without the space would work fine.
Just a though but thank you for your feedback
dre