I am trying to duplicate an applications processes in SSIS, and am having trouble in declaring variables for output. I want to fire off a stored procedure with variables derived from data in an excel spreadsheet. Currently I want to run.
declare @p33 int
declare @p34 int
declare @p35 varchar(8)
exec usp_CreateUser
@Title=?,
@ForeName=?,
@Surname=?,
@GenderType=?,
@DateofBirth=?,
@HomePhone=?,
@UserID=@p33 output,
@PartyId=@p34 output,
@UserNum=@p35 output
select @p33, @p34, @p35
Where ? is the data from the excel sheet, I stupidly thought I could run this as an OLE DB command, but the upfront declare statements cause a syntax error.
Any help appreciated
McD
declare @p33 int
declare @p34 int
declare @p35 varchar(8)
exec usp_CreateUser
@Title=?,
@ForeName=?,
@Surname=?,
@GenderType=?,
@DateofBirth=?,
@HomePhone=?,
@UserID=@p33 output,
@PartyId=@p34 output,
@UserNum=@p35 output
select @p33, @p34, @p35
Where ? is the data from the excel sheet, I stupidly thought I could run this as an OLE DB command, but the upfront declare statements cause a syntax error.
Any help appreciated
McD