"Apending" entire sheet to excel output

[KevinDW]

Hello,

I have been searching everywhere however I do not see if anyone else has tried this before, or if it is even possible.  I have my data flow all built and the final piece I am trying to do, if it is possible, is to have a second sheet in that excel output of my data be populated with static information.  It is not the end of the world if this is not possible, just more of an ease of use so my colleagues then do not have to track down information to decipher what the output is.  It would always be on the output.

[Raj_Singh1]

hi @KevinDW 

please configure as per the screenshot. i hope it answers your question

[mceleavey]

HI @KevinDW ,

If you are trying to output to Sheet 2 then Sheet3 for example, or to output to a tab for current month (a common one) then you need to create a formula for your output path:

"C:\Users\<User>\Documents\Test\"<Filename>+"|||"+<month>

Then configure your output tool as follows:

This allows you to dynamically determine the sheet name and paste the new data to that sheet accordingly.

I hope this helps.

M.