PRB: SQLXMLBulkLoad Error Message 80046000: "The System Cannot Find The Path Specified" (316361)

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.

REFERENCES

SQL XML Books Online; topic: "Performing Bulk Load of XML Data"

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

316371 SQLXMLBulkLoad Error 80040E14 File Could Not Be Opened Or File Does Not Exist