Issue with tMSSqlOutput - Primary key violation

[Anonymous]

hi,

As i try to insert data, im havving the error;

[statistics] connecting to socket on port 3844
[statistics] connected
Violation of PRIMARY KEY constraint 'PK_B_EQ1996'. Cannot insert duplicate key in object 'dbo.B_EQ1996'. The duplicate key value is (0).
[statistics] disconnected
Job asdasd ended at 04:34 04/05/2016. [exit code=0]

But the component explanation says job will continue;

Insert
[font='Helvetica Neue', Helvetica, Arial, sans-serif]With the Insert action, data will be inserted. If a Primary Key violation occurs, this will be reported, but the Job will continue.[/font]



How can i continue tracnsation even primary key violation occurs?

thanks!

[Anonymous]

attached the job

[Anonymous]

Do you want to terminate and expect the job to fail? If so, go ahead and make check mark on "Die on error" check box.

Hope it helps

Thanks
Rohan Suresh