HResults.DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS Field

There are more than 16 exact match joins, so performance may not be optimal. Reduce the number of exact match joins to improve performance. SQL Server has a limit of 16 columns per index, the inverted index will be used for all lookups.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Const DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS As Integer

public const int DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS

public:
literal int DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS

public static final int DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS

public const var DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS : int

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

HResults Class
HResults Members
Microsoft.SqlServer.Dts.Runtime Namespace