OLE DB or ODBC Error (0x80020005) on Replace Value

[vbiqvitovs]

I'm attempting to replace two values in a column with 9 existing distinct values in the column (queried from local MS-SQL database, 1.1M rows) and I'm running into a Type Mismatch error. This is the only action I am performing, and it continuously fails on this seemly straightforward data clean-up task.

The column type is text, and the replace function is cutting leading text from a value in order to match an existing value in the column.  Example: (Beginning text:text -> text, with multiple instances of text  already found in the column)

This change only requires a single Applied Step and has continued to fail no matter how I attempt to make this change. Is there any way to view a more in-depth error or stack trace?

[vbiqvitovs · Accepted solution]

I fixed this by completely recreating the data model.