Hands-On Microsoft SQL Server 2008 Integration Services part 55. 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. . | 518 Hands-On Microsoft SQL Server 2008 Integration Services 26. Now that you ve completed the configurations of the synchronous transformation component in the Metadata design mode it is time to write some code in the Code design mode. Click Edit Script to open the scripting environment. Let s take some time to understand the auto-generated code and the differences in this code compared to when we create a source. Open the project item. Note that there is only one class with the name of input buffer . XfrInputBuffer and all the columns are exposed as typed properties including the ones that were created in the output. There is only one buffer class instead of the two that one may expect one for input and one for output. This indicates and confirms that in a synchronous transformation the transformations are applied on the same buffer in place and the buffer is passed on to the next component as is without moving data to a new buffer. This enables synchronous transformations to be able to flow the data as it appears in the input and perform the transformations at a very fast speed. The XfrInputBuffer exposes two typed accessor properties for each column one with the column name to refer to the column and the other one with the Column Name _IsNull name used to set the value of a column to null. In the end it contains the AddRow method and the SetEndOfRowset method along with a function EndOfRowset to mark the end of a rowset in the pipeline. Now open the project item. Note that a Processinput method has been provided here. The Processinput method is repeatedly called for each row as it receives the buffers from the upstream component until the end of the rowset is reached. Another subroutine Xfrinput_Processinput is created here. This method is also used in the ScriptMain class in the project item. if you change the name of the input the ComponentWrapper will regenerate the code and will use the updated name in these .
