dts package

[peac3]

Hi guys,

I've got the SQL Statement in DTS Package

declare @proc_type int
declare @result bit
declare @error_message varchar(1000)

select @proc_type = 1
exec etl_stored_procedure ?, ?, ?, @proc_type, @result output, @error_message output

As you guys can see there are 3 question marks there as an input,
is there a way to how to find out the input of the "question mark"?

Thanks guys,

 

[markros]

Your etl_stored_procedure can log these parameters into some table.

PluralSight Learning Library