The multiple data flow tasks has worked 😀

For anyone that happens upon this thread with the same issue, setup one data flow with a flat file output for your header, so if you have 3 columns in the header map that to three columns in your output.

Then do the details row, adding a new file allows you to do a completely new mapping, so you can add for example 30 columns.

Then do another data flow with your footer row.

Add a variable "OutputFile" and set that as the connection string for all three flat file output files. Turn off the "output headers/first row has header names" and also make sure file overwrite is turned off so that each output appends to the file.

John