Microsoft KB Archive/321307

= Cannot Import Catalog in Data Warehouse DTS Task =

Article ID: 321307

Article Last Modified on 9/27/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



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).

Additional query words: plutonium

Keywords: kbbug kbfix kbcommserv2000sp3fix kbqfe kbcommserv2000presp3fix kbhotfixserver KB321307

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.