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, ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
