What is your version of Toad? On the Export Dataset window is there a
camera icon on the bottom left?. If so that is for saving the action.
Once you get the info on the Export Dataset window all set up click the
camera and save that Action.
Once saved go to the main menu Utilities–>Automation Designer. Then
find your Action. From there select it and right click on it to
schedule it or run it.
On 4/17/2012 4:47 PM, kdprelit wrote:
I am trying to automate a flat file export using a specifications file but I’m not sure how to do it. Normally I right-click on the grid to export the results as a flat file and I load my specifications file and it exports perfectly. Is it possible to automate that process?
Thanks for any tips!