i have a sql task which executes a stored procedure which has some variables in it,i want to use the result set to input to next sql tasks in ssis.how do i achieve this.
it looks like this
cretae proc sp1(@ par1 int,@par2 varchar(50),@par3 varchar(50))
declare @var1 varchar(50)
declare @var2 int
declare @var3 int
select @var1=some calculated value
select @var2=some calculated value
create proc sp2(@var1 varchar(50))
create proc sp3(@var2 int)
i am using a sql task to execute the sp1,i need to givs these varibles inside the sp1 as the parameters to next 2 sql tasks which executes sp2 and sp3.how can we do this.