I have source data(for ex 100 rows) want to load into excel sheets(destination), i want to load 10 rows for each sheet,How to implement this in ssis

<form action="https://www.facebook.com/ajax/ufi/modify.php" class="live_1574366712776262_316526391751760 commentable_item autoexpand_mode" data-ft="{"tn":"]"}" data-live="{"seq":1578041412408792}" id="u_jsonp_8_1a" method="post" rel="async" style="margin:0px;padding:0px;"> </form>

You can use a logic as below

http://visakhm.blogspot.in/2013/09/exporting-sqlserver-data-to-multiple.html

Basically you need a for each loop to iterate based on ADO resultset and then inside that you can have execute sql task to create a sheet (table) in excel and then another data flow task to fill it with the data