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 WorkflowFundamental 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 Integration Services objects and how they interact.