Hi All,
We all faced many time the scenario of using IF ELSE statement in SQL and SSIS.
We all faced many time the scenario of using IF ELSE statement in SQL and SSIS.
- IF ELSE is straightforward in SQL. This can be achieved by using CASE statement. Example for CASE Statement will be found in this link
- Through SSIS, we can use Derived Column transformation to achieve this.
Using Derived column, we can write condition like :
Comments
Post a Comment