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