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

Posted on 2011-10-27
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

    Right Click on  the Precedence Constraint (the arrow going to the next task) and select Completion.
    LVL 30

    Assisted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now