Hi,

[autocomplete] showing the same term multiple times.. How to avoid the Duplicate term

We are going to use the SharePoint list adapter in SSIS and populate the list from SQL Server using a nightly job.  We have a list of skills we are importing from our Career site which we are doing nightly via WebService.  By using the SSIS package we can schedule it to run and update the list as required.  Use a distinct select statement on the SQL Server table we are importing

If you have duplicate entries in your list there isn't much a search web part can do here. You can add additional columns to be displayed (like e.g. [ID]) or some other columns that can help user identify proper records.