There is no limitation on the number of SQL statements that can be specified in the file given in the SQLCmdFileName attribute.
Every SQL statement should be terminated with a semicolon at the end.
SQL comments are not supported in the file. C style comments are supported but will be stripped off before the request is sent to the DBS.
The statements supported in the file are regular SQL statements and substitutions using '@' on job variables is not supported.