Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Dynamically color code column / row in excel destination Expand / Collapse
Author
Message
Posted Thursday, February 24, 2011 11:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 6:57 PM
Points: 148, Visits: 640
Does anyone know or have examples of how to color code a column(s) or row(s) based on certain values for an Excel destination within SSIS?
Post #1069138
Posted Thursday, February 24, 2011 12:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
tan110 (2/24/2011)
Does anyone know or have examples of how to color code a column(s) or row(s) based on certain values for an Excel destination within SSIS?


I'm afraid you can't do that natively in SSIS.
Either you build some custom formatting into the excel before the data is written into it, or you write a script task in SSIS that does the formatting after the data has been written or you build a macro into the Excel file that does the formatting.

Yet another option is to build a report in SSRS, do the formatting there and then dump it to Excel.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1069187
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse