Chapter 10. Data Flow Transformations

In This Chapter

Row Transformations

Split and Join Transformations

Rowset Transformations

Other Transformations

Business Intelligence Transformations

Summary

Most of your packages will require that you work with and modify data. The data and schema are modified in Integration Services using Data Flow transformations. In this chapter, you will explore these preconfigured transformations in detail. You will also be working with five Hands-On exercises that will cover most of the transformations from the perspective of their usability. As you progress in the chapter, the Hands-On exercises will include more and more complex transformations and business scenarios, and of course they will be more interesting as well. ...

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

Start your free trial