Summary

You created an Integration Services blank project in Chapter 1. In this chapter, you created packages using the SSIS Import and Export Wizard and then added those packages into your blank project. You also created a package directly in the BIDS again using the SSIS Import and Export Wizard. But, above all, you explored those packages by opening component properties and configurations and hopefully better understand the constitution of an Integration Services package. In the next chapter, you will learn about the basic components, the nuts and bolts of Integration Services packages, before jumping in to make complex packages in Chapter 4 using preconfigured components provided in BIDS.

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.