Cannot Import Catalog in Data Warehouse DTS Task (321307)

The information in this article applies to:

Microsoft Commerce Server 2000

This article was previously published under Q321307

SYMPTOMS

When you import a catalog in a Data Warehouse Data Transformation Services (DTS) task, you may receive the following error message:

Error -2147217900 Msg: Idispatch error #3092 Description: There is already an object named '#CatTmp' in the database

CAUSE

When you import the catalog, the dynamic Structured Query Language (SQL) in the dynamic-link library (DLL) creates a temporary table named #CatTmp, but does not detect the catalog and does not drop the catalog correctly for later use if the user is not a Database Owner (DBO).

RESOLUTION

To resolve this problem, obtain the latest service pack for Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack

The English version of this fix should have the following file attributes or later:

   Date         Time   Size   File name    
   ----------------------------------------
   16-Apr-2002  15:40  525KB  Cdtstasks.dll

STATUS

Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000. This problem was first corrected in Commerce Server 2000 Service Pack 3 (SP3).

Modification Type:	Minor	Last Reviewed:	9/27/2005
Keywords:	kbHotfixServer kbQFE kbbug kbCommServ2000preSP3fix kbCommServ2000sp3fix kbfix KB321307