Create and drop text file in MII

Hi experts,

I am fairly new to MII. I'm looking for a way to generate a string from a resultset of a query and write this string to a .txt file. This file needs to be dropped on another server.

I made my query which gives me the resultset I need. I can't seem to find the right action to concatenate a string from this. And to write this string to a file. I checked the 'write file' action which should contain a 'message' in the properties but it doesn't.

So which actions should I use for this?

Any guidance would be great!



Helpful Answer