Hands-On Microsoft SQL Server 2008 Integration Services part 51. 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. . | 478 Hands-On Microsoft SQL Server 2008 Integration Services 30. Drop an Excel Destination just below the Splitting Fuzzy Grouped Duplicates component and join both of these components using the green arrow. Select Fuzzy Grouped Matches in the Output field of the Input Output Selection dialog box and click OK. Rename this Excel destination Fuzzy Grouped Duplicates. 31. Double-click the Excel destination to configure it. Select DuplicateOwners Connection in the OLE DB Connection Manager field if it s not already selected. 32. Click the New button next to the Name of the Excel sheet field and verify in the CREATE TABLE statement that it is creating the Fuzzy Grouped Duplicates table . worksheet in Excel then click OK to accept. Select Fuzzy_Grouped_ Duplicates in this field. 33. Go to the Mappings page to create the necessary column mappings automatically. Note that in addition to _key_in _key_out and _score columns the Fuzzy Lookup transformation has added one _Similarity_ColumnName column for each column that participated in the fuzzy grouping. Click OK to close this editor. 34. Drop an OLE DB destination on the Data Flow surface below the Splitting Fuzzy Grouped Duplicates component and join the component to the OLE DB destination using the available green arrow. Select Canonical Row in the Output field of Input Output Selection dialog box and click OK. 35. Double-click the OLE DB destination and select dbo . Owner table in the Name of the table or the view field. Go to the Mappings page and verify that the necessary mappings have been automatically created. Click OK to close this editor. Rename the OLE DB Destination Owner. Press ctrl-shift-s to save all the files in the project. Exercise Execute Removing Duplicates Package Finally execute the package to see how the various transformations remove the duplicate data. 36. You can add the data viewers after each transformation to see the records that have been removed from the pipeline. Later I ve explained how .
