AnsweredAssumed Answered

SQL Count(*)

Question asked by johnlewis604562 on Apr 10, 2018
Latest reply on Apr 10, 2018 by Pete Wirfs
Hi

I have a sql query that does a count of rows, but I am having problems with the code

:DEFINE &ARRAY#, String, 1
:PSET &SQL# = " SELECT count(*) FROM ProcessResults WHERE SSIS_ProcessID = '33940' and IsRunning ='false' "
:SET &HND# = ACTIVATE_UC_OBJECT(JOBS.SQL.RUN_SELECT_QUERY.COUNT)
:PROCESS &HND#

I get invalid handle error thrown at the process line.

Thanks for any help
John

Outcomes