sql-serverssisetlconditional-split

How can I make an SSIS Conditional Split task fail the process if rows are sent to default output

I have a Conditional Split task in my workflow which directs the data to one of three different destinations.

All my data should go to one of these three destinations. If there is data that does not conform to this rule it should cause the process to fail (i.e. nothing gets Loaded and the user is given an error).

Is there any way in SSIS to cause a Conditional Split task to fail the process if data is sent to its default output?

Solution

  • The most simple way to do that is to add a Script Component (Destination) after the Default Output. And Throw an exception from the Script Component. As example (VB.NET)

    Throw new Exception("Condition are not met!")