Is it possible to send Data to an excel spreadsheet with multiple tabs
-
I am wanting move data from an oledb src which is pulling records which are sorted by specific column say ColA. I'd like to send the data to an excel workbook where each tab in the workbook had records for different values from ColA. Ex, tab 1 has records where ColA = 'Dr Suess', Tab2 has records where ColA = 'Dr Evil'.
Can this be done? If so how?
-
dndaughtery (2/24/2011)
I am wanting move data from an oledb src which is pulling records which are sorted by specific column say ColA. I'd like to send the data to an excel workbook where each tab in the workbook had records for different values from ColA. Ex, tab 1 has records where ColA = 'Dr Suess', Tab2 has records where ColA = 'Dr Evil'.Can this be done? If so how?
The tabs in the workbook are called sheets in Excel terminology. Is the list of sheets where you want to send your data predefined or it will be dynamic? If the list is predefined, you can use the standard Conditional Split transformation and based on your requirements direct the input data to the appropriate Excel Destination sheet.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
No my ColA values could be different with more or less distinct values with each execution.
-
dndaughtery (2/24/2011)
No my ColA values could be different with more or less distinct values with each execution.OK, but would the number of sheets or the name of the sheets change?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply