I am trying to perform a Fuzzy Grouping transformation but I keep getting this error: [Fuzzy Grouping ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Parse error at line: 1, column: 102: Incorrect syntax near 'int'.".
I have created a Data Flow Task and in it I have an OLE DB Source connected to a Fuzzy Grouping transformation connected to a Flat File Destination. The error pops up on the Fuzzy Grouping transformation and I can't figure out why the error would say "Incorrect syntax near 'int'." when it's coming from a table. If anyone can point me in the right direction.