SSIS Export to Excel - Formatting Excel Output
Posted on 2010-01-12
Just wondeirng if this would be possible within SSIS..
I am using SSIS to extract data from 3 different views created in sql and populate 3 different excel sheets within the same spreadsheet with the respective results.
I am using the File System task to delete the spreadsheet and the Execute Sql Task to recreate each of the sheets within the spreadheet before populating them with the respective data.
The package runs successfully and emails the excel output.No issues. Is there anyway that one could apply conditional formatting/formatting (highlighting,bold,etc) to the information in the sheets/spreadsheet from within SSIS before the report is emailed out?
If so, please can you provide some information on how this can be done.