MSSQLROW - The multi-part identifier count not be bound

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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