Hi Karmi

Could you show as CREATE TABLE statement for both source & dest. tables.

I'm afraid you are unable to insert data due to nonnulable column deifinition (inc_status) in DWH.DBO.incident.

The NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new row

without adding a value to this field.

Br.

Mike