MSSQLROW - The multi-part identifier count not be bound

One Star

MSSQLROW - The multi-part identifier count not be bound

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.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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