Setting Up Book Samples


A number of sample packages and other projects are referenced heavily in this book. You can copy these samples to your hard drive so that you can learn by playing. On the sample CD that accompanies this book, there is a folder at the root called SAMPLES. In Windows Explorer, simply drag that folder to a location on your machine's hard drive.

At the root of the SAMPLES folder is a file called README.TXT. It explains how to set up your machine so that the packages run without having to change them in any way. Here are the instructions as found in the readme file:

Each sample is kept in a folder named in similar convention to the chapter folders. Chapter folders are named 'C' followed by the chapter number and simple name. Sample folders are named 'S' followed by the chapter number and simple name of their corresponding chapter. For example, samples for Chapter 12, C12-Variables, are in a folder called S12-Variables.

To run the samples, create the following environment variables at the command prompt:

SET SSISSAMPLESROOT=D:\SSISBOOK\SAMPLES

This is the root folder where the samples are stored.

SET SSISSAMPLESERVER=MYMACHINE\SS2K5RTM

This is the name of the server where the sample database is attached.

SET SSISSAMPLESWORKINGFOLDER=D:\SSISBOOK\SCRATCH

This is where packages put any temporary files they create.

Don't append a '\' to the end of these paths. All the packages append it as part of their configurations.

Each package in the samples has an environment variable configuration that uses these environment variables to build paths to the scripts and other resources. After you have this set up correctly, each of the packages should run without modification.



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net