Chapter 20. The Stock Data Flow Components

IN THIS CHAPTER

Common Component Conventions

Source Adapters

Flow Control Transforms

Auditing Transforms

Data Manipulation Transforms

Destination Adapters

“I DON’T WANT TO BE SMART!”—ASHVINI SHARMA

This chapter is an introduction to the stock components, the standard Data Flow Task components that ship with Integration Services. Integration Services ships with a wide range of data manipulation transforms and adapters, and so this chapter, like Chapter 8, “The Stock Tasks,” provides a general explanation of each component, highlighting their more notable features, their purpose, how to set them up, some tips and tricks, as well as some of the more interesting and/or less-documented component ...

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.