Hi guys,
Getting this error on my DBConnect outputs when run manually or at a schedule:
message='Unrecognized SQL escape '' at line position 67.'
Using "jTDS driver with Windows Authentication". Errors when trying to insert field values to columns/tables. Tried changing Column "Data Types" but to no avail. Has anyone experienced this before?
Thanks a lot.
Kind regards,
Jeremy
I'll have to answer my question here as I was able to successfully resolve this on my Lab environment. I'm not an SQL person and copying the field names of my source data to use as column names in my destination SQL table was the root cause of the problem. It turns out if you have brackets, braces or periods in your column names, you'll get the "SQL Escape" error. I just renamed my column names and removed the brackets, braces and periods and replace them with underscores.
I'll have to answer my question here as I was able to successfully resolve this on my Lab environment. I'm not an SQL person and copying the field names of my source data to use as column names in my destination SQL table was the root cause of the problem. It turns out if you have brackets, braces or periods in your column names, you'll get the "SQL Escape" error. I just renamed my column names and removed the brackets, braces and periods and replace them with underscores.