SSIS Documentation

Contents

• Fuzzy Lookups
  • Enter Package Lineage Info
  • Fuzzy and Auditing
    • Components
      • Convert Unicode
      • Add some auditing
      • Split the Customer Names
      • Have we seen this guy before
      • Source For Fuzzy
      • Believe new
      • Believe Duplicates
      • Split on likelihood of being a duplicate
  • Connections
    • Pass2005 Munich

Fuzzy Lookups Version: 1.0.36

Property	Value
PackageFormatVersion	2
VersionComments
CreatorName	VM_XP_LAP\Administrator
CreatorComputerName	VM_XP_LAP
CreationDate	10/4/2005 1:25:18 PM
PackageType	DTS Designer 90
ProtectionLevel	1
MaxConcurrentExecutables	-1
PackagePriorityClass	0
EnableConfig
CheckpointFileName
SaveCheckpoints
CheckpointUsage	0
SuppressConfigurationWarnings
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	English - United Kingdom
TransactionOption	Supported
DelayValidation
ObjectName	Fuzzy Lookups
Description
DisableEventHandlers
LoggingMode	Use Parent Setting

Connections

• OLEDB: Pass2005 Munich

Property	Value
Retain
ConnectionString	Data Source=.;Initial Catalog=PASS Europe 2005;Provider=SQLOLEDB.1;In

Enter Package Lineage Info

(Execute SQL Task)

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact	Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Enter Package Lineage Info
Description	Execute SQL Task
DisableEventHandlers
LoggingMode	Use Parent Setting

Fuzzy and Auditing

(Data Flow Task)

Pipeline pipelineXml

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact	Performs high-performance data extraction, transformation and loading
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Fuzzy and Auditing
Description	Data Flow Task
DisableEventHandlers
LoggingMode	Use Parent Setting

Component Convert Unicode
Data Conversion Output
Name Description Type Length Precision Scale TaskNameConverted str 128 0 0 Data Conversion Output
Data Conversion Error Output
Name Description Type Length Precision Scale ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 Data Conversion Error Output
Component Add some auditing
Audit Output 1
Name Description Type Length Precision Scale Execution instance GUID guid 0 0 0 Task name wstr 18 0 0 Audit Output 1
Component Split the Customer Names
Derived Column Output	Default Output of the Derived Column Transformation
Name Description Type Length Precision Scale FirstName str 50 0 0 LastName str 50 0 0 Derived Column Output
Derived Column Error Output	Error Output of the Derived Column Transformation
Name Description Type Length Precision Scale ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 Derived Column Error Output
Component Have we seen this guy before
MatchIndexOptions	1
MatchIndexName
ReferenceTableName	_x005B_dbo_x005D_._x005B_DestinationForFuzzyLookup_x005D_
DropExistingMatchIndex	1
CopyReferenceTable	1
MaxOutputMatchesPerInput	1
MinSimilarity	0
Delimiters	_x0020__x0009__x000D__x000A__x002C_._x003B_:-_x0022__x0027__x0026__x0
ReferenceMetadataXml	_x003C_referenceMetadata_x003E__x003C_referenceColumns_x003E__x003C_r
MaxMemoryUsage	0
Exhaustive	false
WarmCaches	true
Connections
OleDbConnection
Fuzzy Lookup Output
Name Description Type Length Precision Scale Col1 i4 0 0 0 FirstName str 50 0 0 LastName str 50 0 0 BelievedDuplicateInDestination i4 0 0 0 _Similarity r4 0 0 0 _Confidence r4 0 0 0 Fuzzy Lookup Output
Component Source For Fuzzy
CommandTimeout	0
OpenRowset	[dbo].[SourceForFuzzyLookup]
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage	1252
AccessMode	0
ParameterMapping
AlwaysUseDefaultCodePage	false
Connections
OleDbConnection
OLE DB Source Output
Name Description Type Length Precision Scale Col1 i4 0 0 0 ColCustomerName str 50 0 0 OLE DB Source Output
OLE DB Source Error Output
Name Description Type Length Precision Scale Col1 i4 0 0 0 ColCustomerName str 50 0 0 ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 OLE DB Source Error Output
Component Believe new
CommandTimeout	0
OpenRowset	[dbo].[DestinationForFuzzyLookup]
OpenRowsetVariable
SqlCommand
DefaultCodePage	1252
AccessMode	3
FastLoadKeepIdentity	false
FastLoadKeepNulls	false
FastLoadOptions	TABLOCK,CHECK_CONSTRAINTS
FastLoadMaxInsertCommitSize	0
AlwaysUseDefaultCodePage	false
Connections
OleDbConnection
OLE DB Destination Error Output
Name Description Type Length Precision Scale ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 OLE DB Destination Error Output
Component Believe Duplicates
CommandTimeout	0
OpenRowset	[dbo].[DestinationForFuzzyLookup_Dups]
OpenRowsetVariable
SqlCommand
DefaultCodePage	1252
AccessMode	3
FastLoadKeepIdentity	false
FastLoadKeepNulls	false
FastLoadOptions	TABLOCK,CHECK_CONSTRAINTS
FastLoadMaxInsertCommitSize	0
AlwaysUseDefaultCodePage	false
Connections
OleDbConnection
OLE DB Destination Error Output
Name Description Type Length Precision Scale ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 OLE DB Destination Error Output
Component Split on likelihood of being a duplicate
Very High Chance A Duplicate	Output 1 of the Conditional Split Transformation
Not Sure Is A Duplicate	Default Output of the Conditional Split Transformation
Conditional Split Error Output	Error Output of the Conditional Split Transformation
Name Description Type Length Precision Scale ErrorCode i4 0 0 0 ErrorColumn i4 0 0 0 Conditional Split Error Output