Four Stars

tMSSqlInput component, invalid escape sequence

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. 

 

 

3 REPLIES
Four Stars

Re: tMSSqlInput component, invalid escape sequence

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

Re: tMSSqlInput component, invalid escape sequence

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

Re: tMSSqlInput component, invalid escape sequence

You're right. Thank you.

 

I corrected it but the problem still persist.