Due to security implications of stored procedures being able to perform tasks such as drop tables and inserts, the data source is limited to select statements.
Try to extract the query from the stored procedure into a select statement, either directly, or by scheduling a job on the server which drops the result of the stored procedure into a single table.
Mike
