SSIS Adding column to excel sheet template destination when importing from SQL Table Source
When you do Export data from the database (using the wizard - Import\Export)

select -- write a query to specify data transfer.



If you are creating package from scratch using BIDS, then in the execute sql task editor, in the sql statement 



then in the data flow task in the source query specify T-SQL query as below :