Can we use command activity to run a small SQL

[vinay_renu2001]

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.....

Any suggestions??


Thanks

[ray.wurlod]

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.