Temporary Table Is Not Used in Data Import (312979)
The information in this article applies to:
- Microsoft Commerce Server 2000 SP2
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.
RESOLUTIONTo 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
STATUSMicrosoft 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).
| Modification Type: | Minor | Last Reviewed: | 9/23/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbCommServ2000preSP3fix kbCommServ2000sp3fix kbfix KB312979 |
|---|
|