Hi

I'm quite new to SSIS - using 2008 version.

I have a job that uses a few data flow tasks. On the third one I'm getting a primary key violation on the last row that it needs to insert, but only sometimes!

I'd like to ignore this problem for now and let the job continue. I have set the MaximumErrorCount property to 10 for the DataFlowTaks, the SequenceContainer and for the Package but still taks fails and this causes the package to stop.

Could anyone please advise how I can get the package to ignore the error?

Thanks

Rob.