Summary

This chapter's goal was to get you acclimated with the main SSIS wizards. The Import and Export Wizard is a quick way to create a package that does a simple import or export of data. The wizard can produce a package that can be run multiple times. The Package Installation Wizard is a method to deploy your SSIS project after its development is complete.

You were then taken on a tour of the Business Intelligence Development Studio (BIDS), which is where you'll be spending most of your time as you develop packages. You looked at the key parts of the interface and learned how to create your first simple package.

Now that you've gotten your feet wet, it's time to see the real power of SSIS, which lies in the multitude of tasks you can use in your packages. You'll learn about some of the more common ones in Chapter 3 and about the advanced transforms in Chapter 4.