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

Posted on 2011-10-27
Medium Priority
Last Modified: 2013-11-10
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.

Question by:lwilliams1809
LVL 22

Accepted Solution

8080_Diver earned 1000 total points
ID: 37040297
Right Click on  the Precedence Constraint (the arrow going to the next task) and select Completion.
LVL 30

Assisted Solution

by:Reza Rad
Reza Rad earned 1000 total points
ID: 37048946
in addition to what 8080_Diver said;
also set MaximumErrorCount property of package to an appropriate value to prevent the package failure.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question