I'm running DTSX packages programmatically via
Microsoft.SqlServer.Dts.Runtime.Package. In the job in question I'm running one large job exporting some millions of records to CSV and in parallel I'm
running smaller jobs doing the same for several thousands of records. The latter ones are also run in parallel with the limit of 3 concurrent jobs at a time. Eventually the large job throws "Access is Denied" exception claiming it cannot "create a file to
spool a long object on the directories named in the BLOBTempStoragePath". I could trade-off performance but I would like to run smaller jobs in parallel rather than wait for large job to complete.
Here is the full text of the exeption
The errors were:
10/21/2010 5:57:56 AM: -2147024891: Access is denied.
10/21/2010 5:57:56 AM: -1073446887: The buffer manager could not get a temporary file name. The call to GetTempFileName failed.
10/21/2010 5:57:56 AM: -1073446893: The buffer manager could not create a temporary file on the path "C:\DOCUME~1\ovz\LOCALS~1\Temp\1&qu
View Complete Post