The package can be saved to a file system Hands-On Exercise 2 shows how you
may import the package created by the Ch 2 project to the SQL Server 2005
Management Studio.
Chapter 2
[ 69 ]
Hands-On Exercises
Exercise 1 has been completely described in the main body of this chapter. Please
follow Exercise 2 and Exercise 3 step-by-step as described.
Hands-On Exercise 1
Create a SSIS Project as described in this chapter and get acquainted with the various
windows. In doing so, try the following variations:
1. Use the default package and get acquainted with the windows and menus.
Rename the package by right-clicking and choosing the Rename option.
Execute the package (before or after renaming) by right-clicking and
choosing the Execute Package option. Make sure you notice a tabbed page,
Progress, added to the Canvas. Now look at the Progress page as well as the
Output window.
2. Try adding different tasks from the Control Flow items of the toolbox (both
by dragging and double-clicking) and try to understand the added task by
right-clicking and looking at the properties.
3. Save the package and explore the folder where it gets saved. Verify if it is at a
different location from the one described in this chapter.
Hands-On Exercise 2
In this exercise, you will import the package that you created in Ch 2 in MS SQL
Server 2005 Management Studio.
1. Click and open the SQL Server Management Studio by clicking on the
shortcut in All Programs as shown.
Pages:
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66