Toad World® Forums

Automation - Select to FIle Activity


In version 2.7, I have a script that connects to sql server, executes a SQL file and exports the results to a .csv file. The log shows it exports 40K rows to the file but then is followed by two successive exports of 0 rows to the save file. Any idea what’s happening?


Can you post a script and log file or send them directly to me ( for investigating?




Found the issue. I had commented out two lines at the end of the script. Once removed, the automation script ran as expected. Thanks for viewing.