3.1 Lookup and Fuzzy Lookup Components with Error Output

2021-11-02
The following example is taken from [Haselden], with modifications.
The following package file illustrates a Pipeline Task that contains several components within the pipeline. The Microsoft SQL Server Integration Services (SSIS) user interface in the designer that represents this package example is shown in the following diagram.
pictc8f9da80-2557-447f-8289-418cc363984e
Figure 3: Pipeline Task in Integration Services user interface
The Lookup Component has both a standard output and an error output. In the case of error output from the Lookup Component, the data flow path is different from the case in which the lookup operation succeeds. In the following structure example, the inputs element and the outputs element of the Lookup Component illustrate its two different output paths.
 <?xml version="1.0"?>
 <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" 
                 DTS:ExecutableType="SSIS.Package.2">
   <DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property>
   <DTS:Property DTS:Name="VersionComments"></DTS:Property>
   <DTS:Property DTS:Name="CreatorName">Kirk Haselden</DTS:Property>
   <DTS:Property DTS:Name="CreatorComputerName">ROMEO</DTS:Property>
   <DTS:Property DTS:Name="CreationDate" DTS:DataType="7">
     7/16/2005 3:59:24 PM</DTS:Property>
   <DTS:Property DTS:Name="PackageType">5</DTS:Property>
   <DTS:Property DTS:Name="ProtectionLevel">0</DTS:Property>
   <DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property>
   <DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property>
   <DTS:Property DTS:Name="VersionMajor">1</DTS:Property>
   <DTS:Property DTS:Name="VersionMinor">0</DTS:Property>
   <DTS:Property DTS:Name="VersionBuild">51</DTS:Property>
   <DTS:Property DTS:Name="VersionGUID">
     {87D0FDC5-59D6-45C3-93DF-442F40DE90CC}</DTS:Property>
   <DTS:Property DTS:Name="EnableConfig">-1</DTS:Property>
   <DTS:Property DTS:Name="CheckpointFileName"></DTS:Property>
   <DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property>
   <DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property>
   <DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
   <DTS:Property DTS:Name="LastModifiedProductVersion">10.0.1600.22
   </DTS:Property>
   <DTS:Property DTS:Name="ForceExecValue">0</DTS:Property>
   <DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property>
   <DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property>
   <DTS:Property DTS:Name="Disabled">0</DTS:Property>
   <DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property>
   <DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property>
   <DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property>
   <DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property>
   <DTS:Property DTS:Name="LocaleID">1033</DTS:Property>
   <DTS:Property DTS:Name="TransactionOption">1</DTS:Property>
   <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
   <DTS:Property DTS:Name="ObjectName">FuzzyLookup</DTS:Property>
   <DTS:Property DTS:Name="DTSID">{ECF155AC-F433-4930-A0A1-BE9B065E004D}
   </DTS:Property>
   <DTS:Property DTS:Name="Description"></DTS:Property>
   <DTS:Property DTS:Name="CreationName">SSIS.Package.2</DTS:Property>
   <DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property>
   <DTS:ConnectionManager>
     <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">.\SQL2K5.AdventureWorks
     </DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {FAFAC1E8-81D4-4E0D-A5A9-ABAD9BF38826}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName">OLEDB</DTS:Property>
     <DTS:PropertyExpression DTS:Name="ServerName">@[SAMPLES::SERVERNAME]
     </DTS:PropertyExpression>
     <DTS:ObjectData>
       <DTS:ConnectionManager>
         <DTS:Property DTS:Name="Retain">0</DTS:Property>
         <DTS:Property DTS:Name="ConnectionString">
 Data Source=.;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;
 </DTS:Property>
       </DTS:ConnectionManager>
     </DTS:ObjectData>
   </DTS:ConnectionManager>
   <DTS:ConnectionManager>
     <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">New Contacts</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{E97F2191-17D8-400B-9EE6-7823482A958C}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property>
     <DTS:PropertyExpression DTS:Name="ConnectionString">
 @[SAMPLES::ROOTWD] + "\\SAMPLEDATA\\NewContacts.txt"</DTS:PropertyExpression>
     <DTS:ObjectData>
       <DTS:ConnectionManager>
         <DTS:Property DTS:Name="FileUsageType">0</DTS:Property>
         <DTS:Property DTS:Name="Format">Delimited</DTS:Property>
         <DTS:Property DTS:Name="LocaleID">1033</DTS:Property>
         <DTS:Property DTS:Name="Unicode">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowDelimiter" 
                       xml:space="preserve">_x000D__x000A_</DTS:Property>
         <DTS:Property DTS:Name="ColumnNamesInFirstDataRow">-1</DTS:Property>
         <DTS:Property DTS:Name="RowDelimiter" 
                       xml:space="preserve"></DTS:Property>
         <DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="TextQualifier">&lt;none&gt;</DTS:Property>
         <DTS:Property DTS:Name="CodePage">1252</DTS:Property>
         <DTS:Property DTS:Name="ConnectionString">
 E:\BOOKSHARE\BOOKS\SSIS\SSIS_R2\SAMPLES\SAMPLEDATA\NewContacts.txt
 </DTS:Property>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x0009_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">50</DTS:Property>
           <DTS:Property DTS:Name="DataType">129</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">FirstName</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
             {64661EFB-1C85-47C6-974D-BDFC7441D404}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x000D__x000A_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">50</DTS:Property>
           <DTS:Property DTS:Name="DataType">129</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">LastName</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
             {2DEA7754-8936-4BFB-822E-F0014DE3C9C0}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
       </DTS:ConnectionManager>
     </DTS:ObjectData>
   </DTS:ConnectionManager>
   <DTS:Configuration>
     <DTS:Property DTS:Name="ConfigurationType">2</DTS:Property>
     <DTS:Property DTS:Name="ConfigurationString">SSISSAMPLESROOT
     </DTS:Property>
     <DTS:Property DTS:Name="ConfigurationVariable">
 \Package.Variables[SAMPLES::ROOTWD].Properties[Value]</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Configure The Root Folder
     </DTS:Property>
     <DTS:Property DTS:Name="DTSID">{90405045-3A91-43C2-B759-6C183C0E81A6}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:Configuration>
   <DTS:Configuration>
     <DTS:Property DTS:Name="ConfigurationType">2</DTS:Property>
     <DTS:Property DTS:Name="ConfigurationString">
       SSISSAMPLESERVER</DTS:Property>
     <DTS:Property DTS:Name="ConfigurationVariable">
 \Package.Variables[SAMPLES::SERVERNAME].Properties[Value]</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Configure The Sample Server Name
     </DTS:Property>
     <DTS:Property DTS:Name="DTSID">{A9F64F24-15C2-4198-A308-F9124C48468D}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:Configuration>
   <DTS:Configuration>
     <DTS:Property DTS:Name="ConfigurationType">2</DTS:Property>
     <DTS:Property DTS:Name="ConfigurationString">SSISSAMPLESWORKINGFOLDER
     </DTS:Property>
     <DTS:Property DTS:Name="ConfigurationVariable">
 \Package.Variables[SAMPLES::WORKINGFOLDER].Properties[Value]</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       Configure the Working Folder variable</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{1BAB0708-C962-4F9B-BFD6-EC434567ACAF}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:Configuration>
   <DTS:Variable>
     <DTS:Property DTS:Name="Expression">@ROOTWD + "\\" + @SAMPLESUBFOLDER
     </DTS:Property>
     <DTS:Property DTS:Name="EvaluateAsExpression">-1</DTS:Property>
     <DTS:Property DTS:Name="Namespace">SAMPLES</DTS:Property>
     <DTS:Property DTS:Name="ReadOnly">0</DTS:Property>
     <DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property>
     <DTS:Property DTS:Name="IncludeInDebugDump">2345</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">CURRENTWD</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{E05C4384-FA46-4EDB-9E41-E0CDD6DD4DC6}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:VariableValue DTS:DataType="8">
 E:\BOOKSHARE\BOOKS\SSIS\SSIS_R2\SAMPLES\S21-Advanced</DTS:VariableValue>
   </DTS:Variable>
   <DTS:Variable>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property>
     <DTS:Property DTS:Name="Namespace">SAMPLES</DTS:Property>
     <DTS:Property DTS:Name="ReadOnly">0</DTS:Property>
     <DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property>
     <DTS:Property DTS:Name="IncludeInDebugDump">2345</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">ROOTWD</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{3BD365BA-FE06-4B5A-8100-69F27C71B74E}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:VariableValue DTS:DataType="8">
       E:\BOOKSHARE\BOOKS\SSIS\SSIS_R2\SAMPLES</DTS:VariableValue>
   </DTS:Variable>
   <DTS:Variable>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property>
     <DTS:Property DTS:Name="Namespace">SAMPLES</DTS:Property>
     <DTS:Property DTS:Name="ReadOnly">0</DTS:Property>
     <DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property>
     <DTS:Property DTS:Name="IncludeInDebugDump">2345</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">SAMPLESUBFOLDER</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{6E7FB8C5-7F98-454E-87E0-D9BF0D0E06AD}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:VariableValue DTS:DataType="8">S21-Advanced</DTS:VariableValue>
   </DTS:Variable>
   <DTS:Variable>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property>
     <DTS:Property DTS:Name="Namespace">SAMPLES</DTS:Property>
     <DTS:Property DTS:Name="ReadOnly">0</DTS:Property>
     <DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property>
     <DTS:Property DTS:Name="IncludeInDebugDump">2345</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">SERVERNAME</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{5F9998D0-186D-4C44-A949-66C8477A3CE7}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:VariableValue DTS:DataType="8">.</DTS:VariableValue>
   </DTS:Variable>
   <DTS:Variable>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="EvaluateAsExpression">0</DTS:Property>
     <DTS:Property DTS:Name="Namespace">SAMPLES</DTS:Property>
     <DTS:Property DTS:Name="ReadOnly">0</DTS:Property>
     <DTS:Property DTS:Name="RaiseChangedEvent">0</DTS:Property>
     <DTS:Property DTS:Name="IncludeInDebugDump">2345</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">WORKINGFOLDER</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{DC4065D8-A163-4893-BE71-FB0D146F3BA8}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:VariableValue DTS:DataType="8">
 E:\BOOKSHARE\BOOKS\SSIS\SSIS_R2\SAMPLES\SCRATCH</DTS:VariableValue>
   </DTS:Variable>
   <DTS:LoggingOptions>
     <DTS:Property DTS:Name="LoggingMode">0</DTS:Property>
     <DTS:Property DTS:Name="FilterKind">1</DTS:Property>
     <DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property>
   </DTS:LoggingOptions>
   <DTS:Executable DTS:ExecutableType="SSIS.Pipeline.2">
     <DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property>
     <DTS:Property DTS:Name="ExecutionAddress"></DTS:Property>
     <DTS:Property DTS:Name="TaskContact">
 Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
 </DTS:Property>
     <DTS:Property DTS:Name="ForceExecValue">0</DTS:Property>
     <DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property>
     <DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property>
     <DTS:Property DTS:Name="Disabled">0</DTS:Property>
     <DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property>
     <DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property>
     <DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property>
     <DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property>
     <DTS:Property DTS:Name="LocaleID">-1</DTS:Property>
     <DTS:Property DTS:Name="TransactionOption">1</DTS:Property>
     <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Data Flow Task</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{7FAA584E-2F45-4786-8410-8E97F54B0E8D}
     </DTS:Property>
     <DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property>
     <DTS:Property DTS:Name="CreationName">SSIS.Pipeline.2</DTS:Property>
     <DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property>
     <DTS:LoggingOptions>
       <DTS:Property DTS:Name="LoggingMode">0</DTS:Property>
       <DTS:Property DTS:Name="FilterKind">1</DTS:Property>
       <DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property>
     </DTS:LoggingOptions>
     <DTS:ObjectData>
       <pipeline id="0" name="pipelineXml" description="pipelineXml" 
                 defaultBufferMaxRows="10000" engineThreads="5" 
                 defaultBufferSize="10485760" BLOBTempStoragePath="" 
                 bufferTempStoragePath="" runInOptimizedMode="false">
         <components>
           <component id="3728" name="New Contact Names" 
               componentClassID="{5ACD952A-F16A-41D8-A681-713640837664}" 
                      description="Flat File Source" localeId="1033" 
               usesDispositions="true" validateExternalMetadata="True" 
                      version="1" pipelineVersion="0" 
                      contactInfo=
 "Flat File Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1">
             <properties>
               <property id="3734" name="RetainNulls" 
                         dataType="System.Boolean" state="default" 
                         isArray="false" description=
             "Specifies whether zero-length columns are treated as null." 
                         typeConverter="" UITypeEditor="" containsID="false" 
                         expressionType="None">false</property>
               <property id="3735" name="FileNameColumnName" 
                         dataType="System.String" state="default" 
                         isArray="false" description=
 "Specifies the name of an output column containing the file name. If no name is specified, no output column containing the file name will be generated." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None"></property>
             </properties>
             <connections>
               <connection id="3733" name="FlatFileConnection" 
                           description="" connectionManagerID=
                           "{E97F2191-17D8-400B-9EE6-7823482A958C}"/>
             </connections>
             <outputs>
               <output id="3729" name="Flat File Source Output" 
                       description="" exclusionGroup="0" 
                synchronousInputId="0" deleteOutputOnPathDetached="false" 
                hasSideEffects="false" dangling="false" isErrorOut="false" 
                       isSorted="false" errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="3745" name="FirstName" description="" 
                        lineageId="3745" precision="0" scale="0" length="50" 
                        dataType="wstr" codePage="0" sortKeyPosition="0" 
                                 comparisonFlags="0" specialFlags="0" 
                                 errorOrTruncationOperation="Conversion" 
                                 errorRowDisposition="FailComponent" 
                                 truncationRowDisposition="FailComponent" 
                        externalMetadataColumnId="3744" mappedColumnId="0">
                     <properties>
                       <property id="3746" name="FastParse" 
                                 dataType="System.Boolean" state="default" 
                                 isArray="false" description=
 "Indicates whether the column uses the faster, locale-neutral parsing routines." 
                         typeConverter="" UITypeEditor="" containsID="false" 
                                 expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="3748" name="LastName" description="" 
                                 lineageId="3748" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                    specialFlags="0" errorOrTruncationOperation="Conversion" 
                                 errorRowDisposition="FailComponent" 
                                 truncationRowDisposition="FailComponent" 
                    externalMetadataColumnId="3747" mappedColumnId="0">
                     <properties>
                       <property id="3749" name="FastParse" 
                                 dataType="System.Boolean" state="default" 
                                 isArray="false" description=
 "Indicates whether the column uses the faster, locale-neutral parsing routines." 
                       typeConverter="" UITypeEditor="" containsID="false" 
                                 expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                 </outputColumns>
                 <externalMetadataColumns isUsed="True">
                   <externalMetadataColumn id="3744" name="FirstName" 
                         description="" precision="0" scale="0" length="50" 
                         dataType="str" codePage="1252" mappedColumnId="0"/>
                   <externalMetadataColumn id="3747" name="LastName" 
                         description="" precision="0" scale="0" length="50"
                         dataType="str" codePage="1252" mappedColumnId="0"/>
                 </externalMetadataColumns>
               </output>
               <output id="3730" name="Flat File Source Error Output" 
                description="" exclusionGroup="0" synchronousInputId="0" 
                deleteOutputOnPathDetached="false" hasSideEffects="false" 
                dangling="false" isErrorOut="true" isSorted="false" 
                errorOrTruncationOperation="" errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="3750" name=
                          "Flat File Source Error Output Column" 
                          description="Flat File Source Error Output Column"
                          lineageId="3750" precision="0" scale="0" length="0"
                          dataType="text" codePage="1252" sortKeyPosition="0" 
                          comparisonFlags="0" specialFlags="0" 
                                 errorOrTruncationOperation="" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                                 externalMetadataColumnId="0" 
                                 mappedColumnId="0"/>
                   <outputColumn id="3731" name="ErrorCode" description="" 
                                 lineageId="3731" precision="0" scale="0" 
                                 length="0" dataType="i4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                            specialFlags="1" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                                 externalMetadataColumnId="0" 
                                 mappedColumnId="0"/>
                   <outputColumn id="3732" name="ErrorColumn" description=""
                                 lineageId="3732" precision="0" scale="0" 
                                 length="0" dataType="i4" codePage="0"
                                 sortKeyPosition="0" comparisonFlags="0" 
                            specialFlags="2" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                                 externalMetadataColumnId="0" 
                                 mappedColumnId="0"/>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="6980" name="Multicast" componentClassID=
                      "{1ACA4459-ACE0-496F-814A-8611F9C27E23}" 
                      description="Creates copies of a dataset." 
                      localeId="-1" usesDispositions="false" 
                      validateExternalMetadata="True" version="0" 
                      pipelineVersion="0" contactInfo=
 "Multicast;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
             <inputs>
               <input id="6981" name="Multicast Input 1" description="" 
                      hasSideEffects="false" dangling="false" 
                      errorOrTruncationOperation="" 
                      errorRowDisposition="NotUsed" 
                      truncationRowDisposition="NotUsed">
                 <externalMetadataColumns isUsed="False"/>
               </input>
             </inputs>
             <outputs>
               <output id="6982" name="Multicast Output 1" description="" 
                       exclusionGroup="0" synchronousInputId="6981" 
                       deleteOutputOnPathDetached="true" hasSideEffects=
                       "false" dangling="true" isErrorOut="false" 
                       isSorted="false" errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="7042" name="Multicast 1" componentClassID=
                      "{1ACA4459-ACE0-496F-814A-8611F9C27E23}" 
                      description="Creates copies of a dataset." 
                      localeId="-1" usesDispositions="false" 
                      validateExternalMetadata="True" version="0" 
                      pipelineVersion="0" contactInfo=
 "Multicast;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
             <inputs>
               <input id="7043" name="Multicast Input 1" description="" 
                      hasSideEffects="false" dangling="false" 
                      errorOrTruncationOperation="" 
                      errorRowDisposition="NotUsed" 
                      truncationRowDisposition="NotUsed">
                 <externalMetadataColumns isUsed="False"/>
               </input>
             </inputs>
             <outputs>
               <output id="7988" name="Multicast Output 2" description="" 
                       exclusionGroup="0" synchronousInputId="7043" 
                deleteOutputOnPathDetached="true" hasSideEffects="false"
                       dangling="true" isErrorOut="false" isSorted="false" 
                errorOrTruncationOperation="" errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="6817" name="Lookup" componentClassID=
                      "{27648839-180F-45E6-838D-AFF53DF682D2}" 
 description="Looks up values in a reference dataset by using exact matching." 
                      localeId="-1" usesDispositions="true" 
                      validateExternalMetadata="True" version="5" 
                      pipelineVersion="0" contactInfo=
 "Lookup;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
             <properties>
               <property id="6820" name="SqlCommand" 
                         dataType="System.String" state="default" 
                         isArray="false" description=
 "Specifies the SQL statement that generates the lookup table." 
                         typeConverter="" UITypeEditor=
 "Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" 
                         containsID="false" expressionType="Notify">select * from [Person].[Contact]</property>
               <property id="6821" name="SqlCommandParam" 
                         dataType="System.String" state="default" 
                         isArray="false" description=
 "Specifies a SQL statement that uses parameters to generate the lookup table." 
                         typeConverter="" UITypeEditor="" containsID="false" 
                         expressionType="Notify">
                 select * from (select * from [Person].[Contact]) [refTable]
                 where [refTable].[FirstName] = ? and [refTable].[LastName] = ?
               </property>
               <property id="6823" name="CacheType" dataType="System.Int32"
                         state="default" isArray="false" description=
                         "Specifies the cache type of the lookup table." 
                         typeConverter="CacheType" UITypeEditor="" 
                     containsID="false" expressionType="None">1</property>
               <property id="6824" name="MaxMemoryUsage" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
            "Maximum Memory Usage for Reference Cache on a 32 bit platform." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">25</property>
               <property id="6825" name="MaxMemoryUsage64" 
                         dataType="System.Int64" state="default" 
                         isArray="false" description=
            "Maximum Memory Usage for Reference Cache on a 64 bit platform." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">25</property>
               <property id="6826" name="ReferenceMetadataXml" 
                         dataType="System.String" state="default" 
                         isArray="false" description=
                "Indicates whether to reference metadata in an XML format." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">
 &lt;referenceMetadata&gt;&lt;referenceColumns&gt;&lt;referenceColumn name="ContactID" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="NameStyle" dataType="DT_BOOL" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="Title" dataType="DT_WSTR" length="8" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="FirstName" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="MiddleName" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="LastName" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="Suffix" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="EmailAddress" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="EmailPromotion" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="Phone" dataType="DT_WSTR" length="25" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="PasswordHash" dataType="DT_STR" length="128" precision="0" scale="0" codePage="1252"/&gt;&lt;referenceColumn name="PasswordSalt" dataType="DT_STR" length="10" precision="0" scale="0" codePage="1252"/&gt;&lt;referenceColumn name="AdditionalContactInfo" dataType="DT_NTEXT" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="rowguid" dataType="DT_GUID" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;referenceColumn name="ModifiedDate" dataType="DT_DBTIMESTAMP" length="0" precision="0" scale="0" codePage="0"/&gt;&lt;/referenceColumns&gt;&lt;/referenceMetadata&gt;
 </property>
               <property id="6827" name="ParameterMap" 
                         dataType="System.String" state="default" 
                         isArray="false" description=
 "Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. Entries in the list are separated by semicolons." 
                         typeConverter="" UITypeEditor="" containsID="true" 
                         expressionType="None">#3745;#3748;</property>
               <property id="6828" name="DefaultCodePage" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Specifies the column code page to use when code page information is unavailable from the data source." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">1252</property>
               <property id="7989" name="ConnectionType" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
    "Specifies the type of connection used to access the reference dataset." 
                        typeConverter="LookupConnectionType" UITypeEditor=""
                        containsID="false" expressionType="None">0</property>
               <property id="7990" name="NoMatchBehavior" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Specifies how the Lookup transformation handles rows without matching entries in the reference data set." 
                         typeConverter="LookupNoMatchBehavior" 
                         UITypeEditor="" containsID="false" 
                         expressionType="None">0</property>
               <property id="7991" name="NoMatchCachePercentage" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Specifies the percentage of the cache that is allocated for rows with no matching entries in the reference dataset." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">0</property>
             </properties>
             <connections>
               <connection id="6822" name="OleDbConnection" description=
               "Connection manager used to access lookup data." 
               connectionManagerID="{FAFAC1E8-81D4-4E0D-A5A9-ABAD9BF38826}"/>
             </connections>
             <inputs>
               <input id="6818" name="Lookup Input" description="" 
                      hasSideEffects="false" dangling="false" 
                      errorOrTruncationOperation="" 
                      errorRowDisposition="NotUsed" 
                      truncationRowDisposition="NotUsed">
                 <inputColumns>
                   <inputColumn id="6852" name="" description="" 
                                lineageId="3745" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="0" 
                                mappedColumnId="0">
                     <properties>
                       <property id="6853" name="JoinToReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
      "Specifies the column in the reference table that a column joins." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         FirstName</property>
                       <property id="6854" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None"/>
                     </properties>
                   </inputColumn>
                   <inputColumn id="6855" name="" description="" 
                                lineageId="3748" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="0" 
                                mappedColumnId="0">
                     <properties>
                       <property id="6856" name="JoinToReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
     "Specifies the column in the reference table that a column joins." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         LastName</property>
                       <property id="6857" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None"/>
                     </properties>
                   </inputColumn>
                 </inputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </input>
             </inputs>
             <outputs>
               <output id="6819" name="Lookup Match Output" description="" 
                       exclusionGroup="1" synchronousInputId="6818" 
                       deleteOutputOnPathDetached="false" 
                       hasSideEffects="false" dangling="false" 
                       isErrorOut="false" isSorted="false" 
                       errorOrTruncationOperation="Lookup" 
                       errorRowDisposition="RedirectRow" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="6848" name="LUFirstName" description=""
                                 lineageId="6848" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                         externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6849" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied."
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         FirstName</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6850" name="LULastName" description="" 
                                 lineageId="6850" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6851" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied."
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         LastName</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7071" name="NameStyle" description="" 
                                 lineageId="7071" precision="0" scale="0" 
                                 length="0" dataType="bool" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7072" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied."
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         NameStyle</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7073" name="Title" description="" 
                                 lineageId="7073" precision="0" scale="0" 
                                 length="8" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7074" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied."
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         Title</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7075" name="MiddleName" description=""
                                 lineageId="7075" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                            externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7076" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         MiddleName</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7077" name="Suffix" description="" 
                                 lineageId="7077" precision="0" scale="0" 
                                 length="10" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7078" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         Suffix</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7079" name="EmailAddress" description="" 
                                 lineageId="7079" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                            externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7080" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         EmailAddress</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7081" name="EmailPromotion" 
                                 description="" lineageId="7081" 
                                 precision="0" scale="0" length="0" 
                                 dataType="i4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7082" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         EmailPromotion</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7083" name="Phone" description="" 
                                 lineageId="7083" precision="0" scale="0" 
                                 length="25" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                    specialFlags="0" errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                    externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7084" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied."
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         Phone</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7085" name="PasswordHash" description=""
                                 lineageId="7085" precision="0" scale="0" 
                                 length="128" dataType="str" codePage="1252"
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7086" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" 
                               expressionType="None">PasswordHash</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7087" name="PasswordSalt" description=""
                                 lineageId="7087" precision="0" scale="0" 
                                 length="10" dataType="str" codePage="1252"
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7088" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         PasswordSalt</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7089" name="AdditionalContactInfo" 
                               description="" lineageId="7089" precision="0"
                                 scale="0" length="0" dataType="nText" 
                                 codePage="0" sortKeyPosition="0" 
                                 comparisonFlags="0" specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7090" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         AdditionalContactInfo</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7091" name="rowguid" description="" 
                                 lineageId="7091" precision="0" scale="0" 
                                 length="0" dataType="guid" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                                 specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                         externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7092" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         rowguid</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="7093" name="ModifiedDate" description="" 
                                 lineageId="7093" precision="0" scale="0" 
                                 length="0" dataType="dbTimeStamp" 
                                 codePage="0" sortKeyPosition="0" 
                                 comparisonFlags="0" specialFlags="0" 
                                 errorOrTruncationOperation="Copy Column" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="FailComponent" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="7094" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="default" 
                                 isArray="false" description=
 "Specifies the column in the reference table from which a column is copied." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         ModifiedDate</property>
                     </properties>
                   </outputColumn>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
               <output id="7992" name="Lookup No Match Output" description=
 "The Lookup output that handles rows with no matching entries in the reference dataset. Use this output when the NoMatchBehavior property is set to &quot;Send rows with no matching entries to the no match output.&quot;" 
                       exclusionGroup="1" synchronousInputId="6818" 
                       deleteOutputOnPathDetached="false" 
                       hasSideEffects="false" dangling="false" 
                       isErrorOut="false" isSorted="false" 
                       errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <externalMetadataColumns isUsed="False"/>
               </output>
               <output id="6829" name="Lookup Error Output" description="" 
                       exclusionGroup="1" synchronousInputId="6818" 
                       deleteOutputOnPathDetached="false" 
                       hasSideEffects="false" dangling="false" 
                       isErrorOut="true" isSorted="false" 
                       errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="6830" name="ErrorCode" description="" 
                                 lineageId="6830" precision="0" scale="0" 
                                 length="0" dataType="i4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                       specialFlags="1" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                       externalMetadataColumnId="0" mappedColumnId="0"/>
                   <outputColumn id="6831" name="ErrorColumn" description="" 
                                 lineageId="6831" precision="0" scale="0" 
                                 length="0" dataType="i4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                          specialFlags="2" errorOrTruncationOperation="" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                         externalMetadataColumnId="0" mappedColumnId="0"/>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="6858" name="Fuzzy Lookup" componentClassID=
                      "{5056651F-F227-4978-94DF-53CDF9E8CCB6}" description=
 "Looks up values in a reference dataset by using fuzzy matching." 
                      localeId="-1" usesDispositions="false" 
                      validateExternalMetadata="True" version="5" 
                      pipelineVersion="0" contactInfo=
 "Fuzzy Lookup;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5">
             <properties>
               <property id="6861" name="MatchIndexOptions" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Indicates whether to reuse an existing fuzzy-match index table or build a new one. The new index table can be temporary, persisted, or persisted and maintained." 
                         typeConverter="tcMatchIndexOptions" 
                         UITypeEditor="" containsID="false" 
                         expressionType="None">1</property>
               <property id="6862" name="MaxMemoryUsage" 
                         dataType="System.Null" state="default" 
                         isArray="false" description=
 "Specifies the maximum amount of memory (MB) that this instance of the Fuzzy Lookup transformation can use.  If 0 is given, then the transform will dynamically adjust it's memory usage based upon it's requirements and available system memory." 
                         typeConverter="" UITypeEditor="" 
                     containsID="false" expressionType="Notify"/>
               <property id="6863" name="MatchIndexName" 
                         dataType="System.String" state="escaped" 
                         isArray="false" description=
 "Specifies the name of the fuzzy-match index table to be reused or the table name in which a newly generated fuzzy-match index table will be written." 
                         typeConverter="" UITypeEditor="" 
                   containsID="false" expressionType="None">
                 ContactsMatchIndex</property>
               <property id="6864" name="ReferenceTableName" 
                         dataType="System.String" state="escaped" 
                         isArray="false" description=
 "Specifies the name of the reference table or view against which to match incoming records." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None">
                 _x005B_Person_x005D_._x005B_Contact_x005D_</property>
               <property id="6865" name="DropExistingMatchIndex" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Indicates whether to drop an existing fuzzy-match index table if transformation is configured to generate a new table and a table with the same name already exists." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">1</property>
               <property id="6866" name="CopyReferenceTable" 
                         dataType="System.Int32" state="default" 
                         isArray="false" description=
 "Whether a copy of the reference table should be made for fuzzy match index construction and subsequent matching.  It is strongly recommended that a copy always be made, otherwise unpredicatable output may result if the contents of the reference table change during package execution (or between executions if reusing a fuzzy match index).  If this property is set to false, the reference table must additionally have a clustered index built upon an integer identity column." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None">1
               </property>
               <property id="6867" name="MaxOutputMatchesPerInput" 
                         dataType="System.UInt32" state="default" 
                         isArray="false" description=
 "Specifies the maximum number of fuzzy matches to return for an input record." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">1</property>
               <property id="6868" name="MinSimilarity" 
                         dataType="System.Single" state="default" 
                         isArray="false" description=
 "Specifies the minimum similarity score required for the match results that the transformation returns." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None">0.65
               </property>
               <property id="6869" name="Delimiters" dataType="System.String"
                         state="escaped" isArray="false" description=
                         "Specifies the set of white-space and punctuation characters used to separate fuzzy match fields into the words used for matching and scoring a fuzzy lookup." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">_x0020__x0009__x000D__x000A__x002C_._x003B_:-_x0022__x0027__x0026__x002F__x005C__x0040__x0021__x003F__x0028__x0029__x003C__x003E__x005B__x005D__x007B__x007D__x007C__x0023__x002A__x005E__x0025_</property>
               <property id="6870" name="ReferenceMetadataXml" 
                         dataType="System.String" state="escaped" 
                         isArray="false" description=
 "Specifies the metadata of the reference table in XML format." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">
 _x003C_referenceMetadata_x003E__x003C_referenceColumns_x003E__x003C_referenceColumn_x0020_name_x003D__x0022_ContactID_x0022__x0020_dataType_x003D__x0022_DT_I4_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_NameStyle_x0022__x0020_dataType_x003D__x0022_DT_BOOL_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Title_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_8_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_FirstName_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_50_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_MiddleName_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_50_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_LastName_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_50_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Suffix_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_10_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_EmailAddress_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_50_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_EmailPromotion_x0022__x0020_dataType_x003D__x0022_DT_I4_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Phone_x0022__x0020_dataType_x003D__x0022_DT_WSTR_x0022__x0020_length_x003D__x0022_25_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_PasswordHash_x0022__x0020_dataType_x003D__x0022_DT_STR_x0022__x0020_length_x003D__x0022_40_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_1252_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_PasswordSalt_x0022__x0020_dataType_x003D__x0022_DT_STR_x0022__x0020_length_x003D__x0022_10_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_1252_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_AdditionalContactInfo_x0022__x0020_dataType_x003D__x0022_DT_NTEXT_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_rowguid_x0022__x0020_dataType_x003D__x0022_DT_GUID_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_ModifiedDate_x0022__x0020_dataType_x003D__x0022_DT_DBTIMESTAMP_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C__x002F_referenceColumns_x003E__x003C__x002F_referenceMetadata_x003E__x000D__x000A_
               </property>
               <property id="6871" name="Exhaustive" dataType="System.Boolean"
                         state="default" isArray="false" description=
 "If true, each input record will be directly compared against EVERY record in the reference table.  This may produce slightly better results, but will be extremely slow unless the number of records in the reference table is very small.  Note that the entire reference table will be loaded into main memory if this option is enabled.  This option is primarily intended for debugging purposes and should be used with care." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None">false
               </property>
               <property id="6872" name="WarmCaches" 
                         dataType="System.Boolean" state="default" 
                         isArray="false" description=
 "If true, Fuzzy Lookup will partially load the error-tolerant index and the reference table into main memory before execution begins.  This can greatly enhance performance if many input rows are to be processed." 
                         typeConverter="" UITypeEditor="" 
                         containsID="false" expressionType="None">true
               </property>
             </properties>
             <connections>
               <connection id="6873" name="OleDbConnection" description=
 "Microsoft SQL Server connection and database in which the fuzzy lookup reference table is located and where the fuzzy match index table will be stored and accessed." 
          connectionManagerID="{FAFAC1E8-81D4-4E0D-A5A9-ABAD9BF38826}"/>
             </connections>
             <inputs>
               <input id="6859" name="Fuzzy Lookup Input" description="" 
                      hasSideEffects="false" dangling="false" 
                      errorOrTruncationOperation="" 
                      errorRowDisposition="NotUsed" 
                      truncationRowDisposition="NotUsed">
                 <inputColumns>
                   <inputColumn id="6924" name="" description="" 
                                lineageId="3745" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                     externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6925" name="JoinToReferenceColumn" 
                                 dataType="System.String" state="escaped" 
                                 isArray="false" description=
 "Name of the reference table column with which the input column should be matched." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         FirstName</property>
                       <property id="6926" name="JoinType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the match is a fuzzy or an exact match." 
                                 typeConverter="tcJoinType" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">2</property>
                       <property id="6927" name="MinSimilarity" 
                                 dataType="System.Single" state="default" 
                                 isArray="false" description=
 "Specifies the minimum textual similarity required between input and fuzzy matched records on values in this particular join column.  Must be a floating point value between 0.0 and 1.0." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">0
                       </property>
                       <property id="6928" name="FuzzyComparisonFlags" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the comparison options for character data. The options are those supported by the FoldString function." 
                                 typeConverter="tcComparisonFlags" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">1</property>
                       <property id="6929" name="FuzzyComparisonFlagsEx" 
                                 dataType="System.UInt32" state="default" 
                                 isArray="false" description=
 "Flags to FoldString that should be used when comparing whether two strings are equivalent." 
                                 typeConverter="tcComparisonFlagsEx"
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">0</property>
                     </properties>
                   </inputColumn>
                   <inputColumn id="6934" name="" description="" 
                                lineageId="3748" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                     externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6935" name="JoinToReferenceColumn" 
                                 dataType="System.String" state="escaped" 
                                 isArray="false" description=
 "Name of the reference table column with which the input column should be matched." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         LastName</property>
                       <property id="6936" name="JoinType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the match is a fuzzy or an exact match." 
                                 typeConverter="tcJoinType" UITypeEditor=""
                                 containsID="false" expressionType="None">2
                       </property>
                       <property id="6937" name="MinSimilarity" 
                                 dataType="System.Single" state="default" 
                                 isArray="false" description=
 "Specifies the minimum textual similarity required between input and fuzzy matched records on values in this particular join column.  Must be a floating point value between 0.0 and 1.0." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" 
                                 expressionType="None">0</property>
                       <property id="6938" name="FuzzyComparisonFlags" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the comparison options for character data. The options are those supported by the FoldString function." typeConverter="tcComparisonFlags" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">1</property>
                       <property id="6939" name="FuzzyComparisonFlagsEx" 
                                 dataType="System.UInt32" state="default" 
                                 isArray="false" description=
 "Flags to FoldString that should be used when comparing whether two strings are equivalent." 
                                 typeConverter="tcComparisonFlagsEx" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">0</property>
                     </properties>
                   </inputColumn>
                 </inputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </input>
             </inputs>
             <outputs>
               <output id="6860" name="Fuzzy Lookup Output" description="" 
                       exclusionGroup="0" synchronousInputId="0" 
                       deleteOutputOnPathDetached="false" 
                       hasSideEffects="false" dangling="false" 
                       isErrorOut="false" isSorted="false" 
                       errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="6930" name="FirstName" description="" 
                                 lineageId="6930" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                            specialFlags="0" errorOrTruncationOperation="" 
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6931" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None"/>
                       <property id="6932" name="SourceInputColumnLineageID"
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" expressionType="None">
                         3745</property>
                       <property id="6933" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor="" 
                                 containsID="false" expressionType="None">0
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6940" name="LastName" description="" 
                                 lineageId="6940" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                           specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                          externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6941" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None"/>
                       <property id="6942" name="SourceInputColumnLineageID"
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" expressionType="None">
                         3748</property>
                       <property id="6943" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor="" 
                                 containsID="false" expressionType="None">0
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6964" name="FLFirstName" description="" 
                                 lineageId="6964" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                             specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                                 externalMetadataColumnId="0" 
                                 mappedColumnId="0">
                     <properties>
                       <property id="6965" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         FirstName</property>
                       <property id="6966" name="SourceInputColumnLineageID" 
                                 dataType="System.Null" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" expressionType="None"/>
                       <property id="6967" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor=""
                                 containsID="false" expressionType="None">0
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6968" name="FLLastName" description="" 
                                 lineageId="6968" precision="0" scale="0" 
                                 length="50" dataType="wstr" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                           specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6969" name="CopyFromReferenceColumn" 
                                 dataType="System.String" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                         LastName</property>
                       <property id="6970" name="SourceInputColumnLineageID" 
                                 dataType="System.Null" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" expressionType="None"/>
                       <property id="6971" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor="" 
                                 containsID="false" expressionType="None">0
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6874" name="_Similarity" description="" 
                                 lineageId="6874" precision="0" scale="0" 
                                 length="0" dataType="r4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                           specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6875" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">1</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6876" name="_Confidence" description=""
                                 lineageId="6876" precision="0" scale="0" 
                                 length="0" dataType="r4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                            specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                           externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6877" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor=""
                                 containsID="false" expressionType="None">2
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6972" name="_Similarity_FirstName" 
                                 description="Column-level similarity score for fuzzy join on column &quot;FirstName&quot;." 
                                 lineageId="6972" precision="0" scale="0" 
                                 length="0" dataType="r4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                          specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                       externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6973" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                            containsID="false" expressionType="None"/>
                       <property id="6974" name="SourceInputColumnLineageID"
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" expressionType="None">
                         3745</property>
                       <property id="6975" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor=""
                                 containsID="false" expressionType="None">3
                       </property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="6976" name="_Similarity_LastName" 
 description="Column-level similarity score for fuzzy join on column &quot;LastName&quot;." 
                                 lineageId="6976" precision="0" scale="0" 
                                 length="0" dataType="r4" codePage="0" 
                                 sortKeyPosition="0" comparisonFlags="0" 
                            specialFlags="0" errorOrTruncationOperation=""
                                 errorRowDisposition="NotUsed" 
                                 truncationRowDisposition="NotUsed" 
                         externalMetadataColumnId="0" mappedColumnId="0">
                     <properties>
                       <property id="6977" name="CopyFromReferenceColumn" 
                                 dataType="System.Null" state="escaped" 
                                 isArray="false" description=
 "Specifies the reference table column that is copied to the output for each match result." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None"/>
                       <property id="6978" name="SourceInputColumnLineageID"
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies the lineage identifier of the input column from which to copy to this output column for each match." 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="true" 
                                 expressionType="None">3748</property>
                       <property id="6979" name="ColumnType" 
                                 dataType="System.Int32" state="default" 
                                 isArray="false" description=
 "Specifies whether the column is used to indicate confidence or similarity." 
                                 typeConverter="tcColumnType" UITypeEditor=""
                                 containsID="false" expressionType="None">3
                       </property>
                     </properties>
                   </outputColumn>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
         </components>
         <paths>
           <path id="6832" name="Flat File Source Output" 
                 description="" startId="3729" endId="6818"/>
           <path id="6984" name="Lookup Output" description="" 
                 startId="6819" endId="6981"/>
           <path id="6985" name="Lookup Error Output" description="" 
                 startId="6829" endId="6859"/>
           <path id="7045" name="Fuzzy Lookup Output" description="" 
                 startId="6860" endId="7043"/>
         </paths>
       </pipeline>
     </DTS:ObjectData>
   </DTS:Executable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsDataFlowDiagram&gt;&lt;dwd:BoundingLeft&gt;-2699&lt;/dwd:BoundingLeft&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
       &lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="31" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="18150" y="7620" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
       &lt;font&gt;
       &lt;ddsxmlobjectstreamwrapper binary="010000009001c0d40100065461686f6d61" /&gt;
       &lt;/font&gt;
       &lt;mouseicon&gt;
       &lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
       &lt;/mouseicon&gt;
       &lt;/diagram&gt;
       &lt;layoutmanager&gt;
       &lt;ddsxmlobj /&gt;
       &lt;/layoutmanager&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Flat File Source" left="-2201" top="0" logicalid="13" controlid="1" masterid="0" hint1="0" hint2="0" width="5662" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800001e1600008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/components/3728" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Looks up values in a reference dataset by using exact matching." left="-1195" top="2863" logicalid="14" controlid="2" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/components/6817" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="205" top="765" logicalid="15" controlid="3" masterid="0" hint1="0" hint2="0" width="825" height="2598" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/paths/6832" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="630" y="1164" /&gt;
       &lt;point x="630" y="2013" /&gt;
       &lt;point x="604" y="2013" /&gt;
       &lt;point x="604" y="2863" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Looks up values in a reference dataset by using fuzzy matching." left="6504" top="3339" logicalid="16" controlid="4" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/components/6858" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Creates copies of a dataset." left="-1353" top="5958" logicalid="17" controlid="5" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/components/6980" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="-345" top="3628" logicalid="18" controlid="6" masterid="0" hint1="0" hint2="0" width="1191" height="2830" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"&gt;
       &lt;adornment percentpos="100" controlid="13" width="2970" height="344" side="0" behavior="2" himetric="2323" distfromline="175" startobj="0" x="-2699" y="5614" visible="1" allowoverlap="1" usepercent="1" /&gt;
       &lt;/polyline&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/paths/6984" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="2" destid="5" sourceattachpoint="5" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="54" y="4027" /&gt;
       &lt;point x="54" y="5475" /&gt;
       &lt;point x="446" y="5475" /&gt;
       &lt;point x="446" y="5958" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="2004" top="3046" logicalid="19" controlid="7" masterid="0" hint1="0" hint2="0" width="4800" height="1275" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="255" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"&gt;
       &lt;adornment percentpos="80.7297356346952" controlid="15" width="2826" height="344" side="0" behavior="2" himetric="3695" distfromline="175" startobj="0" x="2721" y="4096" visible="1" allowoverlap="1" usepercent="1" /&gt;
       &lt;/polyline&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/paths/6985" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="2" destid="4" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="2403" y="3445" /&gt;
       &lt;point x="4453" y="3445" /&gt;
       &lt;point x="4453" y="3921" /&gt;
       &lt;point x="6504" y="3921" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Creates copies of a dataset." left="6663" top="6276" logicalid="20" controlid="8" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/components/7042" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="8063" top="4104" logicalid="21" controlid="9" masterid="0" hint1="0" hint2="0" width="1190" height="2672" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"&gt;
       &lt;adornment percentpos="50" controlid="14" width="423" height="423" side="1" behavior="2" himetric="1082" distfromline="175" startobj="0" x="9028" y="5727" visible="1" allowoverlap="1" usepercent="1" /&gt;
       &lt;/polyline&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}/paths/7045" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="4" destid="8" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="8853" y="4503" /&gt;
       &lt;point x="8853" y="5832" /&gt;
       &lt;point x="8462" y="5832" /&gt;
       &lt;point x="8462" y="6276" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Text" left="-2699" top="5614" logicalid="25" controlid="13" masterid="6" hint1="0" hint2="0" width="2970" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000200009a0b000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d6113004c006f006f006b007500700020004d00610074006300680020004f007500740070007500740000000000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="AnnotationAdornment" value="-1" vartype="11" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" left="9028" top="5727" logicalid="26" controlid="14" masterid="9" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="1" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="VisualizerAdornment" value="-1" vartype="11" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Text" left="2721" top="4096" logicalid="27" controlid="15" masterid="7" hint1="0" hint2="0" width="2826" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000200000a0b000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d6113004c006f006f006b007500700020004500720072006f00720020004f007500740070007500740000000000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="AnnotationAdornment" value="-1" vartype="11" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsDataFlowDiagram&gt;&lt;dwd:DtsComponentDesignerPropertiesList&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3751DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;427TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3881DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6817OverwriteParamsSQLProp&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:boolean"&gt;false&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;536TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3537DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;1TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;536OverwriteParamsSQLProp&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:boolean"&gt;false&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3751TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;536DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6817DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3537TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;1DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6858TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3881TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;Table&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6817TableInfoObjectType&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:int"&gt;0&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3751OverwriteParamsSQLProp&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:boolean"&gt;false&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;3751UsedTableName&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;[Person].[Contact]&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;427DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6858DataSourceViewID&lt;/dwd:key&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;536UsedTableName&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;[Person].[Contact]&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:DtsComponentDesignTimeProperty&gt;&lt;dwd:key xsi:type="xsd:string"&gt;6817UsedTableName&lt;/dwd:key&gt;&lt;dwd:value xsi:type="xsd:string"&gt;[Person].[Contact]&lt;/dwd:value&gt;&lt;/dwd:DtsComponentDesignTimeProperty&gt;&lt;/dwd:DtsComponentDesignerPropertiesList&gt;&lt;/TaskHost&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {7FAA584E-2F45-4786-8410-8E97F54B0E8D}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{5BBFB200-DBD1-428A-BD70-2F2B4FA6848E}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:SourceName&gt;Flat File Source Output&lt;/dwd:SourceName&gt;&lt;dwd:DestinationName&gt;Lookup Input&lt;/dwd:DestinationName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {7FAA584E-2F45-4786-8410-8E97F54B0E8D}-6832</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {2A5D370B-C48E-4515-A29F-72C075ED27DC}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:SourceName&gt;Lookup Match Output&lt;/dwd:SourceName&gt;&lt;dwd:DestinationName&gt;Multicast Input 1&lt;/dwd:DestinationName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {7FAA584E-2F45-4786-8410-8E97F54B0E8D}-6984</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {EA6738C2-7F1C-4779-A540-4B85CD7B377F}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" 
       xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" 
       xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" 
       xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:PathAnnotation&gt;PathName&lt;/dwd:PathAnnotation&gt;&lt;dwd:SourceName&gt;Lookup Error Output&lt;/dwd:SourceName&gt;&lt;dwd:DestinationName&gt;Fuzzy Lookup Input&lt;/dwd:DestinationName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {7FAA584E-2F45-4786-8410-8E97F54B0E8D}-6985</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {ACF27AB3-F2DE-4E03-87F8-6CB55E807799}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" 
       xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" 
       xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" 
       xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:SourceName&gt;Fuzzy Lookup Output&lt;/dwd:SourceName&gt;&lt;dwd:DestinationName&gt;Multicast Input 1&lt;/dwd:DestinationName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {7FAA584E-2F45-4786-8410-8E97F54B0E8D}-7045</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {C6C34E41-0F6A-4D48-8321-89822D3673F7}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" 
       xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" 
       xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" 
       xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
       &lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" 
       mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" 
       defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" 
       defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" 
       version="7" nextobject="5" scale="100" pagebreakanchorx="0" 
       pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" 
       scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" 
       marginy="1000" zoom="100" x="18150" y="9022" backcolor="15334399" d
       efaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" 
       PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" 
       marqueeselectionmode="1" mousepointer="0" snaptogrid="0" 
       autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" 
       donotforceconnectorsbehindshapes="1" 
       backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
       &lt;font&gt;
       &lt;ddsxmlobjectstreamwrapper binary="010000009001c0d40100065461686f6d61" /&gt;
       &lt;/font&gt;
       &lt;mouseicon&gt;
       &lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
       &lt;/mouseicon&gt;
       &lt;/diagram&gt;
       &lt;layoutmanager&gt;
       &lt;ddsxmlobj /&gt;
       &lt;/layoutmanager&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="5622" top="5146" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="4392" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="00080000281100008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {ECF155AC-F433-4930-A0A1-BE9B065E004D}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {659D145B-8BBE-4273-B57A-B579BF934B7E}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" 
       xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" 
       xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" 
       xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
       &lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="5" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="18150" y="9022" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
       &lt;font&gt;
       &lt;ddsxmlobjectstreamwrapper binary="010000009001c0d40100065461686f6d61" /&gt;
       &lt;/font&gt;
       &lt;mouseicon&gt;
       &lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
       &lt;/mouseicon&gt;
       &lt;/diagram&gt;
       &lt;layoutmanager&gt;
       &lt;ddsxmlobj /&gt;
       &lt;/layoutmanager&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="5622" top="5146" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="4392" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="00080000281100008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{7FAA584E-2F45-4786-8410-8E97F54B0E8D}" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">package-diagram</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {85F43B8D-FDD0-4FF1-993B-F53F08AA2A4F}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
 </DTS:Executable>
Share via

3.1 Lookup and Fuzzy Lookup Components with Error Output

Additional resources
