I have scoured the internet and can only find the basics which this appears not to be. So here we go...
I have an excel template file which I am populating with data from a SQL Server database and table.
I can get the data into the spreadsheet on the correct sheet BUT it puts the records outside of an 'Excel Table' leaving a blank but formatted table row. This table is used to populate other sheets / pivot table stuff.
The excel table has a name in this case being the imaginative 'data'.
I need to get my rows to be inserted into the table so that it is picked up and tabulated properly. I am currently thinking it is not possible with the standard SSIS controls and may require 3rd party components to be able to specify exactly where it needs to go in the file but wanted to know if anyone has managed to do precisely this.
An alternative might be to insert the data into the sheet then create the excel table / pivot table over the top of it but I also do not know if that is possible programmatically.