topic tMSSqlInput component, invalid escape sequence in Talend Studio

tMSSqlInput component, invalid escape sequence

Anonymous — Tue, 11 Jul 2017 14:59:59 GMT

Hello,

I am currently starting with Talend and I am facing a problem.

I use DBVisualizer as database tool and I have no error on it. Then I try the same query into Talend. When I use the 'Guess Schema' button, I face the following error :

Invalid escape sequence (valid ones are \b \t \n \f \\" \' \\)

From what I understand, the problem is in the syntax of my query. I should escape "\" with "\\". Then, the point I don't understand is that I have no "\" into my query and still this error.

You will find in attachment the query I use.

If someone can explain to me the origin of the problem, I would be grateful.

Thank you in advance,

best regards.

Re: tMSSqlInput component, invalid escape sequence

Anonymous — Tue, 11 Jul 2017 15:31:04 GMT

I removed the extra quotation mark at the end of the first SELECT, but it is still not working

Re: tMSSqlInput component, invalid escape sequence

cterenzi — Tue, 11 Jul 2017 17:25:26 GMT

The first line still looks a little off. The '1970-01-01' is not part of the DATEADD argument list.

Re: tMSSqlInput component, invalid escape sequence

Anonymous — Wed, 12 Jul 2017 08:30:47 GMT

You're right. Thank you.

I corrected it but the problem still persist.