Create and drop text file in MII
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!