Can I get the last table identity value from DTS Step?
I log DTS package execution into log table and want to mark package completation time at the same table.
At the first step I use Execute SQL Task with statements:
DECLARE @oper_id int
INSERT INTO t_data_oper_log (data_kind, start_time)
VALUES ('Q', getdate())
SET @oper_id = @@identity
SELECT @oper_id as operid
At the same task I'm trying to read "operid" with Parameters.../Output parameters into Global Variable to use it within last task to update completation time.
But GV value is not updated.