Hi - that is correct the primary key conflict is failing the package. When the primary key conflict comes up I would like to see the job fail and the SQL Server Agent fail and send me an email as to what it is doing now by showing successful.

In the Job Properties under Notifications I do have it set to send me an email "When the job fails". In the SSIS package it seems to get to one point fail and skips all other parts.

Thanks,