Automation Designer: Export Dataset new feaure


I just wanted to make a quick post about something coming in Monday's beta. Something that few people will find unless it's documented somewhere.

When using SQL Files as the query source, you can right-click on the filename box and choose "Variables". Until now, variables here were meant as part of the file name, like c:\temp\%my_awesome_variable%\test.sql. That works.

What does NOT work, until now, is using this variable as a means to pass a parameter into the SQL file. Like so:


In which case, the corresponding SQL File would reference the first parameter as &1, the second as &2, and so on. For example:


I hope someone finds this helpful.



Noted. This is brilliant!