Import Sample Data to the Data Warehouse

  • Article

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In the SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand your SQL server, right-click Data Transformation Services, and then click Open Package.

  3. In the Select File dialog box, navigate to <drive:>\Program Files\Microsoft Commerce Server 2002\Predictor Tutorial\, select the file ImportData.dts, and then click Open.

  4. In the Select Package dialog box, select the PredictorDemo Import Data from the list, and then click OK.

  5. In the SQL Server Enterprise Manager, right-click Microsoft OLEDB Provider for SQL Server, and then click Properties.

  6. In the Connection Properties dialog box, verify the Microsoft SQL Server authentication credentials, and then click OK.

  7. Right-click Transaction data import task, and then click Properties.

  8. In the Properties dialog box, verify that the Operation level is shown as Site level, and that the Sitename is PredictorDemo, and then click OK.

  9. Right-click Profile data import task, and then click Properties.

  10. In the Properties dialog box, in the Import start date box, change the date to 1/1/99, and then click OK.

  11. Repeat steps 7 and 8 for the Campaign data import and Product catalog import tasks.

  12. In SQL Server Enterprise Manager, click Execute on the toolbar.

  13. In the Package Execution Results dialog box, click OK.

  14. In the Executing DTS Package: Import data to the data warehouse dialog box, click done when all the tasks are completed.

    Ee811037.note(en-US,CS.20).gifNote

    • If you encounter any errors during setup, it is recommended that you view the log file to determine the source of the error.

  15. Exit SQL Server Enterprise Manager.

Copyright © 2005 Microsoft Corporation.
All rights reserved.