Skip to Content
avatar image
Former Member

Data Flow terminated due to error 70401 - Integrity Constraint Violation

Hi All,

When I am running delta job in production, I am getting Integrity constraint violation;301 unique constraint violated.

dataflow throwing error for 2 target table.

In Query from source schema taking 3 columns and mapping as primary keys in target table.

1.Source Col1 Decimal(19,0) --- Target Col1 Decimal(19,0)

2. Source Col2 varchar(444) ---Target Col2 varchar(10)

3. Source Col3 numeric(6,0) --- Target Col3 varchar(6)

Should be the data types and lengths for source and target same.

I ran full load successfully. No idea of why its giving error for delta load.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers