tMSSqlSCD inserting nulls into surrogate key

[castiellll]

Hello,

While using the tMSSqlSCD component, I get this error "Cannot insert the value NULL into column 'sid_user', table".

sid_user is the surrogate key.

In addition, i can't find the action on table for this component, i need then to manage the table manually.

You will find attached some pictures.

Thank you in advance for your help.

Sofiane.

[manodwhb · Accepted solution]

@castiellll ,is it a new table,if yes you should put one single records to have default. based on that surrogate key column it will increase automatically. check below linke to know more about SCD components

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/khYZl2ImWxITZQVA3BiIDA

[castiellll]

@manodwhb  Thank you for your reply.

Can you be a little bit more precise ?

Should I only insert a value or set something else ?

Thank you in advance.

[castiellll]

Ok I got it. I really need to set the record manually. Thank you very much for your help.

[manodwhb]

@castiellll ,great,please give Kudos also .