Can I use Data Flow Task Plus to write data into multiple worksheets in an Excel file?

Can I use Data Flow Task Plus to write data into multiple worksheets in an Excel file?

Yes, you can use DFT+ with Excel Destination Plus to write data into multiple worksheets in an Excel File. To accomplish this, you will need to use variables and an expression to provide the sheet names to the package. For a demonstration showing how to modify the worksheet name dynamically at runtime, see this video.