Can we use any stage in Sequence to run the SQL to get the row count from a table instead of using a ODBC or native plug-in stage od a database in a job and putting them in a file then reading from the file.....
At the risk of being less efficient, you can use an Execute Command activity to run a script to execute SQL against a database. You may need to strip extraneous newline and white space characters from the command output.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.