Hands-On Microsoft SQL Server 2008 Integration Services part 41. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 378 Hands-On Microsoft SQL Server 2008 Integration Services Most of the business requirements will need you to work with data and make it suitable for deriving some business value out of it. The data and schema are modified in Integration Services using data flow transformations. In this chapter you will explore the preconfigured transformations in detail. You will also be working with 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. To keep such a progression and your interest in the chapter the transformations may not appear in the order in which they appeared in Chapter 9. We ll start with the easiest ones first. Row Transformations Row transformations are simple compared to other types of transformations. Starting with the simplest transformation . Copy Column transformation to copy an input column to output columns we will study the Character Map transformation the Data Conversion transformation and then the Data Derivation transformation. The next two transformations deal with columnar data the Export Column transformation exports partial data from the pipeline into a file and the Import Column transformation reads data from a file and adds it into the pipeline. The ability to perform more complex functions will increase as we go till we reach the last two transformations Script Component and OLE DB Command in this category which can be programmed to perform the functions you want. Let s start our journey with Copy Column transformation. Copy Column Transformation The Copy Column transformation is probably the simplest of the transformations available in the SQL Server Integration Services. It does precisely what it says it copies a column in the data flow to add a new column in the data flow. Sometimes you may need to .
