Archive
Highlighted

Anyone Have Used DBConnect Outputs Before and Was Successful?

Explorer

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

Tags (1)
0 Karma
Highlighted

Re: Anyone Have Used DBConnect Outputs Before and Was Successful?

Explorer

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.

View solution in original post

0 Karma