One is able to execute a stored procedure in the Editor window, but, it fails in the "Select to File Activity"of the "Automation Script", where it shows the error:
File_1 - Unable to parse any SELECT statements from the SQL query
NOTE: the issue doesn't happen in version 3.1