Getting the Status of an XML Import Operation

  • Article

When you are importing an XML file in an asynchronous mode, you need to know the status of your current import operation.

The catalog import creates a temporary table called ##CatalogImportStatusID that contains the status ID of the import operation currently in progress. This table contains a single field called StatusID. The Catalogstatus table contains the status of all the import operations. You can use the StatusID to get the status of the import operation from the Catalogstatus table.

Select @statusid =  StatusID from ##CatalogImportStatusID
Select * from catalogstatus where StatusId = @ statusid

If you have a very large XML file and you continue to get a “Not enough memory to complete this operation” error during import, install Microsoft XML Core Services (MSXML) 4.0.

Copyright © 2005 Microsoft Corporation.
All rights reserved.