I want to perform following using Execute SQL task
declare
@LogID int, @OperationID int
exec
usp_CreateLog@DataProvider
='ABC' ,@Source_Original = '' ,@NoTables = 3 ,@UserName = '@userName' ,@LogID =@LogID output
select
@LogID as LogID
I want @LogID as output. Please suggest how to achive in SSIS