You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to make use of the Generate And Persist New Index Fuzzy Lookup transformation…

Reusing an existing saved index is the purpose of the 'Use Existing Index' option, not 'Generate And Persist New Index'.

Creating a new index without saving it describes the 'Generate New Index' option, which builds a temporary index discarded after the package completes.

When 'Generate And Persist New Index' is selected, the Fuzzy Lookup transformation builds a new full-text index on the reference table and persists it to SQL Server for reuse across package runs. However, this index is not automatically maintained when reference data changes, so it can become stale without manual intervention.

Automatically maintaining the index when reference data changes is not a feature of this option; the persisted index must be manually rebuilt when the reference table is updated.