sql 2005: ssis flow control

Posted on 2011-10-24
Last Modified: 2013-11-10
hi all

i have an ssis app, that uses the  multicast transformation to allow 1 data set to be processed and posted to 2 different tables..

problem i have is, if i get an error in a data flow i want the other flow to also stop, currently it process's away and will post to a sql table regardless

is there some way of delaying this from happening?


Question by:malraff
    LVL 21

    Expert Comment

    by:Alpesh Patel
    make both properties to true for package level as well
    LVL 37

    Accepted Solution

    I don't think that the further processing of your data flow can be stopped by settings.  The only option to get what you want, the way I see it, is to split your data flow up into several.

    First prepare your data and store it in a (temporary) table or raw file.  Then set up additional data flows to put the data into your destination tables.  You can then use precedence constraints in the control flow to prevent further processing in case of error.

    Author Comment

    sorry for no feedback guys - im only back in the office now !

    Author Comment

    i think ur right Valentino!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    760 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

    9 Experts available now in Live!

    Get 1:1 Help Now