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

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:

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

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

This behavior is by design.

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.