Skip to Content

Data Flow terminated due to error 70401 - Integrity Constraint Violation

Jan 24, 2017 at 02:08 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your help in advance.

* Please Login or Register to Answer, Follow or Comment.

0 Answers