Convert query to file

[Former Member]

Hi experts,

I have a sql query working fine and giving me the right result when I am looking for a person MSKEYVALUE  like

Select COLUMNS from TABLE where MSKEYVALUE like '%Something%' --> Work fine

How to convert this result as file and give the end user the possibility to put what he/she wants as "Something/Somet/Som etc" et get result a file.

I able to create To File task but how to create the inputfield and how link it to the inputfield?

Thanks,

Niad

[former_member2987]

Hi Niad,

You can have the final task use a "To ASCII" pass to create the file.  However, the trick is to make sure that users can access the folder you store the output in, and that it gets cleaned up on a somewhat regular basis.

Matt