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