Microsoft KB Archive/316361

= PRB: SQLXMLBulkLoad Error Message 80046000: &quot;The System Cannot Find The Path Specified&quot; =

Article ID: 316361

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q316361



SYMPTOMS
When you run an XML Bulk Load application, the following error message may occur:

Error code 80046000 - One of the temporary files could not be created. Check that the TempFilePath property is valid or that the TEMP environment variable is set. 'The system cannot find the path specified.'



CAUSE
The SQLXMLBulkLoad object with the Transaction property set to True uses the path specified by the Tempfilepath property of the SQLXMLBulkLoad object. If the Tempfilepath property is not specified, the SQLXMLBulkLoad object uses the TEMP user environment variable to create the temporary files needed by the service account of SQL Server for the bulk insert operation. The error message indicates that the account for the XML Bulk Load application cannot find the path specified. This problem usually occurs when you deploy the application on a computer that does not have the valid path as specified by Tempfilepath.



WORKAROUND
To work around this problem, use either one of these methods:  Set the Transaction property to False so the SQLXMLBulkLoad operation can run in a non-transacted mode.

NOTE: This workaround may impact the performance of the bulk load operation. Make sure that the client computer on which you deploy the XML Bulk Load application has:

 A valid path specified by the Tempfilepath property.

-or-

 A TEMP user environment variable set.

The TEMP user environment variable is based on the current user who is logged on to the client computer.

NOTE: SQLXMLBulkLoad uses the TEMP environment variable if Tempfilepath is not specified.