Toad World® Forums

Automation - Select to FIle Activity


#1

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?


#2

Can you post a script and log file or send them directly to me (igor.manokhin@quest.com) for investigating?

Thanks,

Igor.


#3

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.