Chapter 6. The Building Blocks of Integration Services

IN THIS CHAPTER

The Building Blocks of Integration Services

The Package and Other Objects

The Data Flow Task, Adapters, and Transforms

Data Flow Versus Workflow—Fundamental Differences

“THIS IS LIKE LEGO MINDSTORMS PROGRAMMING.”—TYSON HASELDEN

This chapter is a conceptual introduction to Integration Services and sets the stage for later, more technical chapters. It is a gentle introduction to Integration Services concepts. Old Data Transformation Services (DTS) hands will benefit from the discussion as it relates to the updated DTS feature set. Those who have never used DTS will benefit because it gives a high-level view of all the components and a simple introduction to important ...

Get 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.