Chapter 2. Building Your First Package
After completing this chapter, you will be able to:
Explore a SQL Server Integration Services project in SQL Server Business Intelligence Development Studio.
Use the SSIS Import and Export Wizard to create a new Integration Services package.
Review package elements created by the SSIS Import and Export Wizard.
Execute a package and view the results.
In this chapter, you’ll take a first look at the design environment used to create and manage Microsoft SQL Server Integration Services (SSIS) packages. The tools are significantly different than the design environment for SQL Server 2000 Data Transformation Services, with many improvements.
You will learn to use SQL Server 2005 Business Intelligence Development Studio ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.
