I’m experiencing the following issue with with the database activities, specifically Execute Non Query.
A colleague created this code and it uses the database activities to setup a connection to an excel file and query the excel file as if it were a database. This has worked correctly for a long period of time however it has started throwing errors.
I have the following query in the activity "Update [ALL_GENDER$] set [Disability?] = 'N/A' Where [Disability?] IS NULL"
where All_GENDER is the excel sheet and Disability? is a column heading.
As I said, this has worked without any issues for a long period of time however I’m now getting the following error Query '' is corrupt.
I haven’t used these activities before so any suggestions or help would be greatly appreciated.