Question: how to export data from flat file to excel in ssis?
Answer: right click on any database in your server, hover over 'tasks' and select 'import data...'
in 'data source' drop down, select 'flat file source'. ... 
browse to the file you want to import. ... 
in 'destination' drop down, select 'microsoft excel'. ... 
here you can rename columns and preview the end result.