AWDataWarehouseRefresh Package Sample

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
This sample works only with SQL Server 2005 and SQL Server "Katmai". It will not work with any version of SQL Server earlier than SQL Server 2005.
The AWDataWarehouseRefresh sample package illustrates how to create and populate user tables in the new
AdvWorksDWX database, using data from the AdventureWorks database. Several Transact-SQL scripts are executed to create the tables, after which several Execute SQL tasks run to populate the tables.

Important:

Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.

Requirements

Running this sample package requires the following:

The sample package and data files that it uses must be installed on the local hard disk drive.

You must have installed and have administrative permissions on the AdventureWorks OLTP database.

If you intend only to run the sample package from the command line, you must install Integration Services.

If you intend to open the package in SSIS Designer and run the sample package, you must install Business Intelligence Development Studio. The following files are required to run this sample package.

File

Description

AWDWRefresh.dtsx

The sample package.

For more information about how to install samples, see "Installing Sample Integration Services Packages" in SQL Server Books Online.

Location of the Sample Package

If the samples were installed to the default location, the AWDataWarehouseRefresh sample package and data files are located in the following folder:
C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\AWDataWarehouseRefresh\

Note:

If you changed the installation location of the project, you must modify the
BasePath and DataFilePath variables in the package.

Running the Sample

The package can be run from the command line by using the dtexec utility, or can be run in Business Intelligence Development Studio.

To run the package by using dtexec

Open a Command Prompt window.

Use the Change Directory command, cd, to change the directory to C:\Program Files\Microsoft SQL Server\100\DTS\Binn, the location of
dtexec.