scalar query against an ODBC source?

Discussion created by dbc on Sep 15, 2015
Latest reply on Sep 15, 2015 by beverly

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?