Toad automation throws a "Out of Memory" error when exporting data to Excel file.
Running a Select to File automation activity, that saves a large data set to an Excel files gives "Exception of type 'System.OutOfMemoryException'" error. The file is never created and the data cannot be exported.
WORKAROUND 1:
Export to .CSV file instead, which exports 500 rows at a time and streams the data. This can prevent out of memory errors.
WORKAROUND 2:
Break apart the data set into small sets before exporting.
STATUS:
Waiting for fix in a future release of Toad Data Point.
