Export dataset multiple queries

The Folder Iterator is what you want here, but I see that the export dataset's "SQL FIle" feature doesn't support variables. I am adding this for next beta. Assuming all your SQL files are in the same folder, you will be able to do this:

.SQL Files are in a folder called c:\Queries.

Set up your action like this:
image

Folder iterator detail:
image

Export Dataset detail:

then, right-click on the "Folder" action and choose "Run".