Package SQL Create Record - Get Information

Hellos,

Any ideas here will be appreiciated, I am sure I am missing something in my design structure

In a package I am creating SQL record , using a script , this table has contains a simple identity which is a running primark key 
 

Once a record is created, the logs obviously dont' show the ID of the record created since the value (cannot be passed on)
 

How do you propose I ideintify the record , since I need to pass it to a webhook 

CHATGPT suggested something like below , but the output is still not 'captured'

INSERT INTO [items].[basecamp].[delegation] (
    task,
    RelatedDirector
)
OUTPUT INSERTED.ID
VALUES (
    'hello',
    'again'
)
 

Good morning

What is your database type?

Can you provide us with table creation script please and insert statement

Hi,

This is MS - SQL 2022. Please find SQL dump

 
 

I am updating it like below

Instead of SQL Script you can use SQL Record to get value

Here is the script

BEGIN
DECLARE @NewIDTable TABLE (ID INT);
INSERT INTO [delegation] (
    task,
    RelatedDirector
)
OUTPUT INSERTED.ID INTO @NewIDTable
VALUES (
    'hello',
    'again'
)
SELECT ID FROM @NewIDTable;
END

Peter.Jonson wrote:

Instead of SQL Script you can use SQL Record to get value
 

You guys always have an ACE up your sleeve !