July 29, 2011 at 3:26 pm
When importing an excel file using SSIS, is it possible to capture the fill color of a field? I'd like to know if ssis can read whether a field was red vs yellow for example.
July 30, 2011 at 8:13 pm
The answer looks to be no as the formatting is determined by the Jet driver. See: http://www.bigresource.com/Tracker/Track-ms_sql-mw5YvkBz/
July 31, 2011 at 5:54 am
Good to know, thanks!
August 1, 2011 at 12:07 am
You can parse the Excel file using .NET in a script task.
But directly out-of-the-box with the regular SSIS components, no, it is not possible.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply