Hi friends, small clarification in execute sql task.
First i execute stored procedure in sql server create procedure sample (@empno int)
as
begin
select * from sample where empno=@empno
end
and execute procedure exec dbo.sample 7369
That time it retrive what evere 7369 empno that record it retrive. its fine
so iam try to execute this same procedure in ssis by useing execute sql task.
firse i take one variable for empno name scope datatype value
empno package int 0
then i drag and drop execute sql task then in execute sql task in general tab Result set=none and conection type =oledb and connection=loca lhost.sam.sa and sql source type =direct input and sql statement=exec dbo.sample ?
and in parameter mapping i do mapping ther empno like
variable name direction datatype parametername parametersize
user::empno input long newparameter 0
then after i clikck ok then i execute sql task. that time it doesnot given output its given errore.how to i acchive that task plz tell me
First i execute stored procedure in sql server create procedure sample (@empno int)
as
begin
select * from sample where empno=@empno
end
and execute procedure exec dbo.sample 7369
That time it retrive what evere 7369 empno that record it retrive. its fine
so iam try to execute this same procedure in ssis by useing execute sql task.
firse i take one variable for empno name scope datatype value
empno package int 0
then i drag and drop execute sql task then in execute sql task in general tab Result set=none and conection type =oledb and connection=loca lhost.sam.sa and sql source type =direct input and sql statement=exec dbo.sample ?
and in parameter mapping i do mapping ther empno like
variable name direction datatype parametername parametersize
user::empno input long newparameter 0
then after i clikck ok then i execute sql task. that time it doesnot given output its given errore.how to i acchive that task plz tell me