Cannot import product catalog information into the Commerce Server 2000 or Commerce Server 2002 Data Warehouse (278985)

SYMPTOMS

Failure to import product catalog information into the Commerce Server 2000 or Commerce Server 2002 Data Warehouse can be caused by improper SQL Server user permissions. To import catalog data into a Commerce Server 2000 or Commerce Server 2002 data warehouse by using the Product Catalog Import (Commerce Server) DTS package, a user must have the Database Owner (db_owner) role. If the user does not have this role assigned, they will receive the "1 Task(s) failed during execution" message. In the Application event log, the following error occurs:

Event Type: Error
Event Source: Commerce Server 2000
Event Category: None
Event ID: 32794
Date: <Date task was executed>
Time: <Time task was executed>
User: N/A
Computer: <Server Name>
Description: Error state: 1, Severity: 14, Server: <Server Name>, Line#: 1, msg: CREATE TABLE permission denied in database '<Site>_dw'.

RESOLUTION

The user should seek the assistance of the SQL Database Administrator to obtain the appropriate db_owner role for the Data Warehouse.

-OR-

If you are a Commerce Server administrator, you can supply the Global Resource for the site's Date Warehouse with another SQL ID that has the db_owner role. To do this, follow these steps:

Open the Commerce Server Manager.
Click to expand the Global Resources.
Right-click the Data Warehouse for your site, and then select Properties.
On the Connection tab, modify the User ID and Password fields with a SQL ID and password that has db_owner rights to the Data Warehouse database.
Click OK to save these settings,

After the db_owner role has been supplied, the user will be able to successfully import product catalog information into the Data Warehouse by using the Product Catalog Import (Commerce Server) DTS task.