Fuzzy Grouping Transformation Editor (Connection Manager Tab)

Use the Connection Manager tab of the Fuzzy Grouping Transformation Editor dialog box to select an existing connection or create a new one.

Note

The server specified by the connection must be running SQL Server. The Fuzzy Grouping transformation creates temporary data objects in tempdb that may be as large as the full input to the transformation. While the transformation executes, it issues server queries against these temporary objects. This can affect overall server performance.

To learn more about the Fuzzy Grouping transformation, see Fuzzy Grouping Transformation.

Options

OLE DB connection manager
Select an existing OLE DB connection manager by using the list box, or create a new connection by using the New button.

New
Create a new connection by using the Configure OLE DB Connection Manager dialog box.

See Also

Integration Services Error and Message Reference
Identify Similar Data Rows by Using the Fuzzy Grouping Transformation