Learn how to export data into Excel using SSIS. Generate excel dynamically from multiple tables or query. Learn more br br =============================== br This video covers br =============================== br ◾How to export Excel files from multiple tables br ◾How to export Excel file from SQL query br ◾How to export data into multiple Sheets by row countsize or group column br br =============================== br SSIS Export Excel File Task br =============================== br SSIS Export Excel File Task is your one stop solution to create excel reportsworkbooks from SSIS. You don’t need any drivers, no need to worry about metadata issue you face with native SSIS Excel Task. We worked hard to take care most painful tasks for exporting data from any relational source to Excel. br br Features br ◾Export multiple tablesviews to Excel files (e.g. Sales or do SalesJan|SalesFeb) br ◾Support for all major office versions (e.g. Office 2003, 2007, 2013) br ◾Export SQL query output to Excel file br ◾Completely dynamic approach without limitation of DataFlow Stict Metadata br ◾Option to export data to specific starting location in Excel Sheet (e.g A5 will start writng to 5th row 1st column) br ◾Support for Password protected excel file br ◾Option to clear range of cell before writing data to existing excel workbook (e.g. A1:D5000 will clear A to D columns from 1st to 5000 rows) br ◾Automatically Split exported Excel data into multiple files by Size or Number of records br ◾Automatically Split exported Excel data into multiple files or tabs when Split By Column (e.g. SplitBy=Country will create new file for each country, if SplitOnTab option specified then data written to new excel tab rather than file for each new group) br ◾Support for Compression and Append br ◾Fully managed means works out of the box on 32-Bit and 64-Bit without any change (Native SSIS Excel functionality is 32bit only).