you have error (it is SQL server error):
Invalid object name '"+context.SUPPORT_SRC_Database+"."+context.US_SUPPORT_SRC_Schema+".DEMAND_VALIDATION'.
SQL server cannot find object with this name, it is look like in Talend you use additional single quotes around code
1. it is little different query with original - you use different context variables, so may be some other error in text (as it in talend but not here )
"SELECT
DISTINCT A.LOAN_ID
FROM ["+context.MSSQL_Database+"].["+context.MSSQL_Schema+"].[LOAN_REF] A
LEFT OUTER JOIN ["+context.MSSQL_STAGE_Database+"].["+context.MSSQL_STAGE_Schema+"].[LOAN_MST_DT] B WITH (NOLOCK) ON A.LOAN_ID = B.LOAN_ID AND B.MLSTN_TYPE_NM = 'ServiceTransferInDate'
AND B.MLSTN_DTTM >= DATEADD(DAY,-10,CAST(CAST(GETDATE() AS DATE) AS DATETIME))
LEFT OUTER JOIN ["+context.MSSQL_STAGE_Database+"].["+context.MSSQL_STAGE_Schema+"].[LOAN_MSG_CD] FOR SYSTEM_TIME ALL LMC WITH (NOLOCK) ON A.LOAN_ID = LMC.LOAN_ID AND LMC.MSG_CD = '86' AND LMC.END_DTTM >= DATEADD(DAY,-5,CAST(CAST(GETDATE() AS DATE) AS DATETIME))
WHERE CASE WHEN LMC.LOAN_ID IS NOT NULL THEN 1 WHEN B.LOAN_ID IS NOT NULL THEN 1 ELSE 0 END = 1"
you need debug - what query you are send to sql server.
as variant, add context variable SQLtext
before tMSSQLRow add tJava component (connect both by OnSubjobOk)
and in tJava
set context variable
context.SQLtext= ..... all what you want to use as SQL
then print it
System.out.println(context.SQLtext);
in tMSQSQL row use just context.SQLtext without any other quotes
but first - check what it print for You
