We help IT Professionals succeed at work.

export data from database to multiple worksheets of CSV file using SSIS - data flow task

FPHDBA
FPHDBA asked
on
I need to export data from a database to multiple worksheets of a csv file using data flow task in SSIS
Currently my SSIS package is exporting to the .csv file whole data in one worksheet.
But i want to split that data in multiple worksheets using SSIS

Is there any way to accompalish this task?
Comment
Watch Question

Consultant, Trainer
Commented:
you can select the worksheet in your excel destination, and then data will transfer to the selected worksheet.
is that what you mean?
Reza RadConsultant, Trainer
Commented:
and if you want to do it without SSIS, here is good samples:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926