|
Comments:
|
SSIS is a bit limited when generating Excel, you can just generate plain data.
This post explains you a trick to add formatting to your tabular reports, the tricks consists in format an Excel file and use it as template (Excel destination but not over a new file, write over an existing one). This solution won't work for all scenarios, and won't give you all the formatting that you expect, but at least it's something to try before going for a custom script task (XMLSS, Open XML, ...)
|