Microsoft KB Archive/842835

= The Commerce Server Data Warehouse Import Wizard does not save a package on a cluster =

Article ID: 842835

Article Last Modified on 3/14/2007

-

APPLIES TO


 * Microsoft Commerce Server 2002 Service Pack 2
 * Microsoft Commerce Server 2002 Service Pack 1
 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Service Pack 3

-



SYMPTOMS
When you run the Microsoft Commerce Server 2002 Data Warehouse Import Wizard and the package is saved to a SQL cluster, you receive the following error message:

Source: DBNETLIB

Error: SQL Server does not exist or access denied.



CAUSE
This behavior occurs because the Data Warehouse Import Wizard is not cluster aware.



RESOLUTION
To work around this issue, a Data Transformation Services (DTS) package can be manually created and saved. Additionally, you can open the following Commerce2002.dts file in the SQL Enterprise Manager.

The following file is available for download from the Microsoft Download Center:

Download the Commerce2002.exe package now. For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.



STATUS
This behavior is by design.



MORE INFORMATION
You can open and save the Commerce.dts file to Microsoft SQL Server to create a package that is similar to one that the wizard would create.

To do this, follow these steps:
 * 1) Download and then save the Commerce2002.exe package.
 * 2) Open and then extract the contents to a folder on your computer.
 * 3) In SQL Enterprise Manager, right-click Data Transformation Services, and then click Open Package.
 * 4) Locate the Commerce2002.dts file that was extracted in step 2, and then click OK.
 * 5) On the Package menu, click Save As. The Select File dialog box appears.
 * 6) In the Location list, click SQL Server, and then click the correct SQL Server.
 * 7) Edit and then save each task in the package to reflect the correct site and other details. Make sure that you update the Site List in the Web Log Import DTS task to make sure that the log file path is correct.

Keywords: kbprb KB842835

-

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

© Microsoft Corporation. All rights reserved.