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

    scalar query against an ODBC source?

    dbc

      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?