O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

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

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

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