Managed index in Fuzzy Lookup Error

Hot Topic

DTC error with concurrent data flows
Problem with Microsoft.SqlServer.BatchParser.dll on Windows 64-bit
Web Synchronization wizard
server is not a subscriber (SQL2005)
Resources about Load/Run SSIS packages using .NET Remoting.
create a Custom Delivery Protocol class and Auto-Refresh for SQL Grids displaying SQL Server Data
How can i check if Notification Services engine components is insalled or not?
what is IdentifyingAttributes
using UniqueIdentifier list in Select * from table where UniqueIdentifierCol in UniqueIdentifierList
beginner question

SQL Server

SQL Server connection from C#/asp.net
SQL Configuration holding connections to DS
Error while trying to make a remote connection to a named instance of SQL Server 2005
Mobile Application Enquiry
Does anyone know how to fix this?
SQL Agent Failing when trying to run my SSIS Package
Reporting Services Configuration -- Database Setup
Encryption By Passphrase
MDX Calculation & Display Folder ?
Connecting Surface Area Configuration to server on Clustered Server

Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

Answer this question

Managed index in Fuzzy Lookup Error

Sumardi
OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP
Managed index in Fuzzy Lookup Error

Answer this question