Hello all. I am new to Toad Data Point automation. The version of Toad data point I have is 220.127.116.1126 Base Edition Patent Pending. It is hosted on Citrix at our organization.
I have 20 separate sql file scripts. Instead of spending the time and putting all files together into 1 giant unreadable sql file, I would to run all these queries and output a single Excel file with the results of each query on each tab. Each tab would be named according to the query name or something similar.
I have spent a few hours getting familiar with Toad data point and googling to try to find a likewise post out there, but the ones I find have all the sql statements in one file I would much rather not do that because one big file would be difficult to read and maintain overall considering the long, large queries.
Also, when trying the automation tour on executing a script. I found there is no option available to select a results destination. Odd. Connection details have been greyed by me.