From this - it appears that you want to get this output to a CSV file. If so - what are the so-called limitations you are running into with going directly to CSV from SSIS? Probably a lot less time and effort to address those limitations than to worry about issues with exporting from SSIS to Excel.
Phil Parkin - Thursday, December 6, 2018 10:31 AM
Phil - if you add a CHAR(9) to the beginning of a field in Excel it forces that field to be interpreted as a text field and not a numeric field, but that is only when the data in imported into Excel from a comma/tab delimited file. If SSIS is exporting directly to Excel - then you should be able to define the column types in the Excel 'table' as specific data types.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs