O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing Packages

Whether you’re migrating a DTS package or creating a new Integration Services package, you use SQL Server Business Intelligence Development Studio. This development environment is rich with features that can initially seem overwhelming but is much easier to navigate once you understand how package objects are classified and how they fit together to achieve a data integration goal. In this section, we’ll focus on commonly used components and important features of the development environment.

The Development Environment

SQL Server Business Intelligence Development Studio is the graphical interface you use to design, test, and execute a package. While Business Intelligence Development Studio appears to be a distinct application, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required