SQLTeam.com | Weblogs | Forums

Fuzzy Grouping Parse Error


#1

Hello,

I am trying to perform a Fuzzy Grouping transformation but I keep getting this error: [Fuzzy Grouping [2]] 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.

Thanks