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.
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