Microsoft KB Archive/312979

= Temporary Table Is Not Used in Data Import =

Article ID: 312979

Article Last Modified on 9/23/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Service Pack 2

-



This article was previously published under Q312979



SYMPTOMS
The Data Warehouse Catalog Import Data Transformation Services (DTS) task creates and then drops a table in the catalog database during execution. This process uses the connection string with which users on the Web site access the catalog. Because of this, the connection string must be able to drop and add tables on the production database, which poses a possible security risk.



CAUSE
The table is not created as a Microsoft SQL Server temporary table.



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   Version        Size  File name --  28-Nov-2001  18:37  4.0.3017.0  536,848  Cdtstasks.dll 30-Nov-2001 20:09                1,804  Hotfix.txt 13-Jun-2001 14:08  1.0.0.1      28,944  Hotfixsetup.exe 28-Nov-2001 19:29                  453  Qfehotfix.ini 28-Nov-2001 19:27              261,120  Qfepatch.msp 28-Nov-2001 19:29                7,168  Qfeunpatch.msp



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Commerce Server 2000 Service Pack 3 (SP3).

Keywords: kbbug kbfix kbcommserv2000sp3fix kbqfe kbcommserv2000presp3fix kbhotfixserver KB312979

-

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

© Microsoft Corporation. All rights reserved.