OLE DB or ODBC error WE CANNOT apply filed ACCESs to the type text

[Haydeh]

I got this error :

OLE DB or ODBC error WE CANNOT apply filed ACCESs to the type text

I have a model combined a CVs data, and two other tables from SQL.

Please guide me how to solve the issue.

Many Thanks,

Haydeh

[v-jiascu-msft]

Hi @Haydeh,

In which step did you get this error message? Can you locate the error step?

Best Regards,

Dale

[Haydeh · Accepted solution]

Hello Dale,

I solved the problem 🙂

I stepped back my querries, and found 2 errors in my output out of millions records so I wasn't able to see the errors.

Best,

Haydeh

[Haydeh]

On the table that I have my model, all queries run compeletly. when I want to apply my queies I got ths error messege.

Thank you for your quick response,

Haydeh