December 14, 2011 at 4:44 am
how split the data into multiple excel sheets in single excelfile using ssis
December 14, 2011 at 7:59 am
There's no built-in functionality for this as far as I know, but it would be possible to do it with a script task.
Doing it that way will be very cumbersome though...you're going to have to write a lot of .NET code to get that done.
December 14, 2011 at 2:41 pm
You could also do multiple data flows that each write to a specific sheet in the excel file.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2011 at 2:08 am
Jack Corbett (12/14/2011)
You could also do multiple data flows that each write to a specific sheet in the excel file.
Or you could use a conditional split to split the data according to certain conditions and write the different paths to different outputs.
Or you could use a multicast to split the pipeline into multiple flows and then filter the data on each path to have only the data you need for that output.
Or you could provide us with more information and sample input/output so we can provide you with better assistance.
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