Loading with * from Stored Procedure

[#1]

i have a stored procedure on sql.

I am calling the procedure.

But there are about 100 columns of result.

so i want to load thoose results with * char.

The qlikview script code is like below:

Table1:
Add Load *;
SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';

it doesnt load by this way.

but when i write:

Table1:
Add Load column1;
SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';

it loads to data.

The thing is i just don't want to write all of thoose columns.

Thanx

[Anonymous]

Have you tried this?

Table1: 

Add Load column1, *; 

SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData'; 

[#3]

i've tried just right now, but unfortunately not working

OLEDB read failed