SQLTeam.com | Weblogs | Forums

SSIS Excel Export with Report Header

When using an Excel template to export data in SSIS, is there a way insert the query/table data starting lower on the Excel Sheet? I need to include header rows with the report titles first and then insert the header column names and report data. I am familiar with the Sheet1$ OpenRowset configuration, but I can't get it to work, while maintaining the report titles.

image