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?