I am new to Toad for Data Analysts.
I am creating on automated toad script using Toad for Data Analysts.I have created .tas file using Toad for Data Analysts.
For achieving this i have written one sql query which is located on my local machine.Then I am exporting sql query output in excel file on same machine.I have given export excel location to the task.
Now my problem is when i am running this tas on Toad for Data Analysts it is giving me below error message.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
– at System.IO.__Error.WinIOError()
– at System.IO.Path.GetTempFileName()
– at Quest.Toad.ImportExport.ExportEngine.InitLogging()
– at Quest.Toad.ImportExport.ExportEngine…ctor(String wizardXml, Boolean log)
– at Quest.Toad.Workflow.Activities.Database.SelectToExcelActivity.Execute(ActivityExecutionContext executionContext)