# Directory Invalid Error

**URL:** <https://forums.toadworld.com/t/directory-invalid-error/33160>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 22, 2015, 12:27am UTC](https://forums.toadworld.com/t/directory-invalid-error/33160 "2015-04-22T00:27:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![shashikant](https://avatars.discourse-cdn.com/v4/letter/s/edb3f5/32.png) [@shashikant](https://forums.toadworld.com/u/shashikant)\
**Post date:** [April 22, 2015, 12:27am UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/1 "2015-04-22T00:27:01Z")

</div>

Hi,

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](http://System.IO).\_\_Error.WinIOError(Int32 errorCode, String maybeFullPath)  
– at [System.IO](http://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)

![2502.taod_1.jpeg](https://global.discourse-cdn.com/quest/original/2X/a/af395148b77ef6f1dd0d34fe0f8a14b2c7174f69.jpeg)

---

<div class="post-metadata">

**Author:** ![mcourcy](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@mcourcy](https://forums.toadworld.com/u/mcourcy)\
**Post date:** [November 3, 2015, 1:12pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/2 "2015-11-03T13:12:14Z")

</div>

I recently migrated to a server with Windows 2012R2 and am now getting this error for exports that are included in automation. Tried both csv and excel. Any solution to this?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 3, 2015, 5:58pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/3 "2015-11-03T17:58:25Z")

</div>

We are asking the operating system for the temp directory and it is not returning a valid path. Does your temp dir exist yet?

---

<div class="post-metadata">

**Author:** ![mcourcy](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@mcourcy](https://forums.toadworld.com/u/mcourcy)\
**Post date:** [November 3, 2015, 6:46pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/4 "2015-11-03T18:46:53Z")

</div>

If you mean by way of environment variables being set, then yes - temp directory has been defined and I’ve verified the folder actually exists…

![temp.jpeg](https://global.discourse-cdn.com/quest/original/2X/0/02e224bd4c1e3a783d2799883dd76fc7979682c4.jpeg)

---

<div class="post-metadata">

**Author:** ![mcourcy](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@mcourcy](https://forums.toadworld.com/u/mcourcy)\
**Post date:** [November 5, 2015, 7:34am UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/5 "2015-11-05T07:34:40Z")

</div>

Debbie - is there a way I can verify in toad what temp directory it is looking for?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 5, 2015, 6:15pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/6 "2015-11-05T18:15:47Z")

</div>

If you have this directory, can write to this dir and still get this error then I suggest you make a support ticket. Is this Citrix or AppV environment by any chance?

---

<div class="post-metadata">

**Author:** ![planomax](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@planomax](https://forums.toadworld.com/u/planomax)\
**Post date:** [November 8, 2015, 4:29pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/7 "2015-11-08T16:29:44Z")

</div>

Some enterprise IT groups won’t allow writing to a temp dir as a way to stop users from installing software. Could be done via virus software. Virus software could also be a cause in it’s own way.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 20, 2015, 5:29pm UTC](https://forums.toadworld.com/t/directory-invalid-error/33160/8 "2015-11-20T17:29:51Z")

</div>

Our app wont work without being able to write to a temp dir
