Unable to fetch data using a Stored Procedure

[harshb10]

I'm using the following query in the data load editor to load data from a stored procedure.

Table_name:
Load *;
SQL exec [db_name].[dbo].[SP_name];

Output: 

"Connected

Creating search index Search index creation completed successfully

"

The connection is successfully established but I'm unable to fetch any data from the stored procedure.

What can be the issue? Thanks in advance..