Split the Table into multiple excel files using ssis

Question

There is a table with 5000 records ,I need to split it into 10 excel files with names Jan_DEpt_Records.xlsx,Feb_Deptname_Records.xlsx etc.How to achieve this with ssis.

Here "Dept" part of the excel name would come from the source table dept column.

It has been understood the use of for each loop and dataflow task inside foreachloop.

Rahul Sharma · Accepted Answer · 2014-11-28 10:18:20Z

1

You should use conditional splits and in that you can right the cases for the number of records and than pass it to your excels just replace derived columns with the sample excel.insert indentity column on basis of that you can differentiate : enter image description here

answered Nov 28, 2014 at 10:18

Rahul Sharma

4533 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1254579 Over a year ago

Thanks Rahuk,but how would i get the excel sheet with name.The part of the name has to be derived from one of the tables column

Collectives™ on Stack Overflow

Split the Table into multiple excel files using ssis

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related