We help IT Professionals succeed at work.

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

FPHDBA asked
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?
Watch Question

Consultant, Trainer
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
and if you want to do it without SSIS, here is good samples: