In this SSIS Tutorial we will cover IF Statement.
SSIS IF Statement is a very common task when we use Data Flow Tasks and you often perform it using Derived Column Transformation.
You may have done IF Expressions in SSRS, Excel or T-SQL, but how to do IF statement in SSIS? That's what I will show you in this article.
SSIS IF Statement common examples:
SSIS IF Examples using derived column
Below are some examples of SSIS IF statement with various scenarios which you can put inside your SSIS derived column. For the purpose of this SSIS Step by step tutorial we will use SSIS 2008 R2 but these examples should work with SSIS 2005, SSIS 2012 and 2014.
Before we dive in let's discuss the syntax.
Many people may find a the syntax a bit odd at the beginning (like myself) unless you are experienced with c# programming but nothing to worry about I will explain each element which should make it much easier to understand.
Below is the syntax:
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month