I have a Control Flow that starts with an Action which inserts a row into a SQL Server table, which then returns the ID of the newly created row. The output of the Action is as follows.

action_8 {

      #ImportID

}

I simply want to store that ID into a variable so it can then be used to update the same row at the end of the Control Flow.

I've tried using Set Variable but can't seem to find a way to reference the data.

Any help greatly appreciated.