topic tMSSqlSCD inserting nulls into surrogate key in Talend Studio

tMSSqlSCD inserting nulls into surrogate key

castiellll — Fri, 15 Mar 2019 10:35:32 GMT

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.

Re: tMSSqlSCD inserting nulls into surrogate key

manodwhb — Fri, 15 Mar 2019 10:41:31 GMT

@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

Re: tMSSqlSCD inserting nulls into surrogate key

castiellll — Fri, 15 Mar 2019 11:04:26 GMT

@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.

Re: tMSSqlSCD inserting nulls into surrogate key

castiellll — Fri, 15 Mar 2019 11:14:47 GMT

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

Re: tMSSqlSCD inserting nulls into surrogate key

manodwhb — Fri, 15 Mar 2019 11:16:58 GMT

@castiellll ,great,please give Kudos also .