Storing Date-time in a variable from tMSSQLinput query and using it in another tMSSQLinput
Hi Everybody,
I'm very new to TOS and I have almost a similar situation in MS SQL where i'm suppose to insert latest records to a table AC. So I'm trying to get max Date from AC to know which records to fetch from another SQL DB. For this as per above diagram i have started with a tMSSQLinput_1 component with above mention query then i want to store the result set of tMSSQLinput_1 to tSetGlobalVar_2 (not sure if this is the best approach). As you can see i have added a Key and just to test if the results are stored i have used tLogRow_1 Component. but i am getting this error
"Execution failed : object is not an instance of declaring class Job AgentCubeNew ended at 20:59 06/03/2019. [exit code=0]"
I would like to know is this the right approach?, also where should i write globalMap.put("myValue",*value*) to set the value in my variable from the query ?
Once i'm able to set the variable i would like to call it in another MSSQLinput component to get records from another db table which > max(date) of table AC
i tried it without tGlobalVariable still the same Class Cast exception. i even tried changing the date format by "Select format(max(Date), 'dd-MM-yyyy') as mdt from AgentCube" same error. when i guess schema after this updated query the system reads it as string with 400 length
