topic Re: MSSQLROW - The multi-part identifier count not be bound in Talend Studio

MSSQLROW - The multi-part identifier count not be bound

Anonymous — Sat, 16 Nov 2024 10:57:07 GMT

I have use this component to retrieve data from sql server table. it is a select statement.
"SELECT col1,Count(col2)
FROM TableA a, TableB b
WHERE TableA.= TableB.
AND CONVERT(varchar(12), IMPORTED, 101)=CONVERT(varchar(12), GETDATE(), 101)
AND TableA. ="+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"
GROUP BY col1"
The multi-part identifier "filename.DAT" could not be bound.

Please help.

Re: MSSQLROW - The multi-part identifier count not be bound

Anonymous — Fri, 13 Nov 2015 03:40:37 GMT

Hi,
You are using tMSSqlRow to execute select statement? Have you tried to use tMSSqlInput to see if it works? What's the error message you are facing?
tXXXRow component is usually used to any type of sql statement excepts select statement, we use txxxInput component to execute a select statement.

Best regards
Sabrina

Re: MSSQLROW - The multi-part identifier count not be bound

Anonymous — Tue, 17 Nov 2015 02:50:45 GMT

I missed single quote around ((String)globalMap.get("tFileList_1_CURRENT_FILE")) this variable.
it should look like '"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+'"
Thanks