006_SSIS execute sql task 调用存储过程

if OBJECT_ID(‘usp_t013_inset_process_log‘) is not null
drop procedure usp_t013_inset_process_log
go
	create procedure usp_t013_inset_process_log
	@execution_id varchar(50),
	@package_name varchar(50),
	@machine_name varchar(50),
	@id int output
	as
	begin
		insert into T013_PROCESS_LOG values(@execution_id,@package_name,@machine_name,GETDATE(),null,1);
		select @id = @@IDENTITY;
	end
	return 1;
go

declare @id_ int
declare @return_value int 
execute ? = usp_t013_inset_process_log
@execution_id = ?,
@package_name = ?,
@machine_name = ?,
@id = ? output