topic Re: Problem with tMSSQLInput, Invalid Column Name in Talend Studio

Problem with tMSSQLInput, Invalid Column Name

_AnonymousUser — Wed, 26 Feb 2014 18:05:40 GMT

HiI have a problem with the tMMSQLInput component, when I select the table from the "..." button near the Table Name Field, and then do a Select * from MyTable I get a column named Document_No_ but when I try to do a Select Document_No_ from MyTable I get an error message :
Exception in component tMSSqlInput_1
java.sql.SQLException: Ivalid column name : 'Document_No_'.
What should I do to solve this problem ?
Thanks for your help.

Re: Problem with tMSSQLInput, Invalid Column Name

Anonymous — Wed, 26 Feb 2014 21:45:56 GMT

Check the query and try it with removed ` chars. Mostly they are more disrupting the code than help.

Re: Problem with tMSSQLInput, Invalid Column Name

_AnonymousUser — Thu, 27 Feb 2014 09:36:39 GMT

I didn't used the quotes around the column name in the Query, it was only for the example. Here's my real query :
"SELECT *
FROM \"IEC$Purchase Header\", \"IEC$Purchase Line\"
WHERE \"IEC$Purchase Header\".No_ = \"IEC$Purchase Line\".Document_No_"

Re: Problem with tMSSQLInput, Invalid Column Name

_AnonymousUser — Thu, 27 Feb 2014 10:58:44 GMT

Hi
Inusual name columns
Try to put between square brackets each column name, something like this:
"SELECT *
FROM ,
WHERE = "
SQL is interpreting that the column Document_No_ has a schema called "IEC$Purchase Line" caused by the dot in the middle of the name.
Hope it helps you.
Cheers