3 Replies Latest reply on Sep 15, 2015 3:39 PM by beverly

    scalar query against an ODBC source?


      What is the best way to perform a simple scalar query against an ODBC source?


      e.g.  SELECT count(custid) FROM customer

      which returns a single numeric 4325


      or SELECT name FROM customer where custid='1023'

      which returns a single field value "John Smith"


      or a stored procedure: CALL customeridexists(custid)

      which returns 1 or 0 (true or false)


      ExecuteSQL script step doesn't seem to return results.

      Import Record (from ODBC Source) works... but defining a table with a single field seems really clunky.


      Am I missing something obvious?