Is it possible to export data to a blank excel file? When creating an excel destination, the transformation requires mappings to column headers. I simply want to tell the package to export the data to cell locations that I set in the Openrowset i.e. Sheet1$A1:A8, but unless there are column headers it won't work.
In a test excel file I create 2 column headers, in the same column on different rows e.g
However, I want to drop data into column B and C etc. Do I have to create column headers? It doesn't seem to be possible without them.