topic Re: tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema in Talend Studio

tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

Ray0801 — Thu, 19 Aug 2021 07:27:01 GMT

I have created a microsoft sql server connection,

the connection is succesfull no issues on that,

When I give all the details and click on Get schema.

I am getting the attached error.

Re: tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

Anonymous — Thu, 19 Aug 2021 08:59:19 GMT

The 'Guess schema' button is used to guess the schema based on the SQL in the query field, make sure you have written the SQL in the query field, from my experiences, it only works for simple query, we usually add manually the columns on the schema to map the selected fields of query.

Regards

Shong

Re: tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

Ray0801 — Thu, 19 Aug 2021 13:37:29 GMT

@shong,I am getting this error even when I try selecting s single column

Re: tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

Anonymous — Mon, 23 Aug 2021 07:40:11 GMT

Can you please provide the following information for us to be more better evaluate the issue, we need to check if it was a bug.

Which version of studio?

Which operating system?

A sample SQL?

Regards

Shong

Re: tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

Ray0801 — Mon, 23 Aug 2021 08:23:00 GMT

@Shicong Hong Version:Talend Open Studio 7.3.1

OS:Windows 10

Query: "Select * from Source_Table"