Differential Duplicate SSIS Package fails prematurely

When running the Differential Duplicate SSIS Package, the job may fail prematurely when the following error:

Message
Executed as user: [user name] /FILE "[...]FindDifferentialDuplicateConstituents.dtsx" 
CONNECTION DBConnection; Data Source=SQLServerInstance;Initial Catalog=BBCRMDBName;
Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;\"" /CHECKPOINTING OFF  /REPORTING EWCDIMicrosoft
(R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 64-bit 
Copyright (C) Microsoft Corporation 2010. All rights reserved.   
Started:  6:58:21 AM  Info: 2011-08-06 06:58:22.61    
Code: 0x4004300A     Source: Find Duplicates SSIS.Pipeline    
Description: Validation phase is beginning.  End Info  Warning: 2011-08-06 06:58:23.35    
Code: 0x8020832B    
Source: Find Duplicates Fuzzy Lookup [1]    
Description: The length of input column 'NAME' is not equal to the length of the reference column '[NAME]' that it is being matched against.  End Warning  Info: 2011-08-06 06:58:25.64    
Code: 0x4004300A    
Source: Find Duplicates SSIS.Pipeline    
Description: Validation phase is beginning.  End Info  Warning: 2011-08-06 06:58:25.66    
Code: 0x8020832B    
Source: Find Duplicates Fuzzy Lookup [1]    
Description: The length of input column 'NAME' is not equal to the length of the reference column '[NAME]' that it is being matched against.  End Warning  Warning: 2011-08-06 06:58:25.66    
Code: 0x80047076    
Source: Find Duplicates SSIS.Pipeline    
Description: The output column "_Confidence" (19) on output "Fuzzy Lookup Output" (3) and component "Fuzzy Lookup" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. 
End Warning  Warning: 2011-08-06 06:58:25.66    
Code: 0x80047076    
Source: Find Duplicates SSIS.Pipeline    
Description: The output column "_Similarity_NAME" (852) on output "Fuzzy Lookup Output" (3) and component "Fuzzy Lookup" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. 
End Warning  Warning: 2011-08-06 06:58:25.66    
Code: 0x80047076    
Source: Find Duplicates SSIS.Pipeline    
Description: The output column "_Similarity_ADDRESS" (856) on output "Fuzzy Lookup Output" (3) and component "Fuzzy Lookup" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. 
End Warning  Info: 2011-08-06 06:58:25.67    
Code: 0x40043006    
Source: Find Duplicates SSIS.Pipeline    
Description: Prepare for Execute phase is beginning.  End Info  Info: 2011-08-06 06:58:25.67    
Code: 0x40043007    
Source: Find Duplicates SSIS.Pipeline    
Description: Pre-Execute phase is beginning.  End Info  Warning: 2011-08-06 06:58:26.30    
Code: 0x8020832B    
Source: Find Duplicates Fuzzy Lookup [1]    
Description: The length of input column 'NAME' is not equal to the length of the reference column '[NAME]' that it is being matched against.  End Warning  Info: 2011-08-06 07:05:01.08    
Code: 0x4004300C    
Source: Find Duplicates SSIS.Pipeline    
Description: Execute phase is beginning.  End Info  Error: 2011-08-06 07:05:01.67    
Code: 0xC020901C    
Source: Find Duplicates OLE DB Source [41]    
Description: There was an error with output column "NAME" (92) on output "OLE DB Source Output" (51). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". 
End Error  Error: 2011-08-06 07:05:01.67    
Code: 0xC020902A    
Source: Find Duplicates OLE DB Source [41]    
Description: The "output column "NAME" (92)" failed because truncation occurred, and the truncation row disposition on "output column "NAME" (92)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. 
End Error  Error: 2011-08-06 07:05:01.67    
Code: 0xC0...  Process Exit Code 1.  The step failed.
 
Contact Support and reference this article; our administrators will investigate the dtsx package. 

Steps to Duplicate

Manually start the Differential Duplicate SSIS Package job.  

Environment

 2.9.1001, patch 33

Was this article helpful?