SQL Server 2008 SSIS Package - if Task fails need to continue to next task

I have an SSIS package that extracts some data from Server A then decides whether to do an UPDATE or INSERT into table data on Server B.
Question: if Task fails for a particular table or transformation how can I tell it to GOTO the next Tasks in the package connected via a precedence constraint. Is this done by the Precedence Constraint or some other setting. I thought there was a way in SSIS or DTS to say "Keep going if you encounter an error.

Thanks
lwilliams1809Asked:
Who is Participating?
 
8080_DiverConnect With a Mentor Commented:
Right Click on  the Precedence Constraint (the arrow going to the next task) and select Completion.
0
 
Reza RadConnect With a Mentor Consultant, TrainerCommented:
in addition to what 8080_Diver said;
also set MaximumErrorCount property of package to an appropriate value to prevent the package failure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.