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 properties. Only the stock components are covered in this chapter. Chapter 21, "Using the Script Component," covers the Script Component and Chapter 22, "Advanced Data Flow Transforms," covers the Slowly Changing Dimension and other advanced transformations.

Note

As noted in other sections of this book, Data Flow Adapters and transforms are generally called data flow components, which is also how this chapter refers to them.

Some sample packages are provided to help you understand stock component basics and how to set them up. Each package provides a quick template to draw from when building your own packages. As you read about each of the components in this chapter, it will help your understanding to open the sample package and tinker with it a bit; it's also the quickest way to learn how to set up and use each of the components.