Create a Folder and
Populate it with the Components We Will Need
prepare for our session with the Execution Log, we will create a folder
to house the DTS package to which we have referred earlier, along with
other files that we will need to complete our practice exercise. Working with
copies of the files will mean that we can comfortably proceed in a practice
environment without concern about "returning things to the way they were,"
should we later wish to perform similar exercises in our development or
production environments (where it would obviously be appropriate to maintain
proper source control over the respective objects). The folder can be created
anywhere on the PC that is convenient from a local perspective.
to launch Windows Explorer.
Navigate to a
convenient place to create the folder that will contain the "collateral"
for our practice session.
folder named as follows:
folder appears similar to that depicted in Illustration 1.
Illustration 1: New
Folder in Place to House Lesson Components
the following folder (or it's equivalent, if your installation differs from
C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\ExecutionLog
folder should contain
the following four files:
select all four files noted above.
the highlighted selection.
from the context menu that appears, as shown in Illustration 2.
Illustration 2: Select
Copy from the Context Menu
and enter, the RS013 folder we created above.
from the context menu that appears, as depicted in Illustration 3.
Illustration 3: Placing
Copies of the Components into the New Folder
the four files appear in the new folder.
now ready to create a database to house the data from the Execution Log.
In doing so, we will make use of the files we have placed in the folder we
created in this step.