Chapter 3. Nuts and Bolts of the SSIS Workflow

In This Chapter

Integration Services Objects

Solutions and Projects

File Formats

Connection Managers

SSIS Variables

Precedence Constraints

Integration Services Expressions


So far, you have moved data using the SSIS Import and Export Wizard and you’ve viewed packages by opening them in the Business Intelligence Development Studio (BIDS). In this chapter, you will learn the difference between an Integration Services project and a solution, file formats, and use of variables. If you have used Data Transformation Services (DTS 2000), you may grasp these issues quickly; don’t skip this chapter, however, as it includes concepts totally new to Integration Services. Usability and management of variables ...

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.