In this step by step SSIS Tutorial I will show you how to use Conditional Split Transformation with Default Output Name. For the purpose of this tutorial I will use SSIS 2012
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well
SSIS Default Output Name
In this example I will show you how to split input into male, female and unknown output using SSIS 2012 Conditional Split. In order to achieve that we will use Default Output Name
In this article we will focus on Default Output Name and our example is based on previous article SSIS Conditional Split Transformation where we discussed the basics.
My source has the data below.
What is Default Output Name? It is an output that we can use when input rows don't meet any condition. In these cases we can direct the rows to Default Output otherwrise we would LOSE ROWS and in most cases we don't want that behaviour.
See below Default Output Name that we called Unknown
I added extra derived column and set it to Unknown Output (Default Output). We had two rows with Gender "U" that didn't meet any condition in conditional split transformation window and you can see that instead of losing these rows we used Default Ouptut.
I hope that help