How to filter null value rows by using Conditional Split Transformation in SSIS

Scenario:

Sometime we have Null values coming from Source. In this post we will learn how to redirect those records by using Conditional Split Transformation.

For this post, I have created a sample data file by using below data.

ID,Name
1,Aamir
2,Raza
,
,  
,  
3,John
4,Sam
,Rebecca

Step 1: 
Create an SSIS Package and bring the Data Flow Task to Control Flow Pane.Inside Data Flow Task bring the Flat File Source. Create the connection to the text file.
Fig 1: Create connection to text file by using Flat File Source


Check the property as shown  below to convert the blank into Null values in Flat File Source.
Fig 2: Convert the blank values to Null values in Flat File Source


Step 2:
Bring the Conditional Split Transformation to the Data Flow Pane and connect Flat File Source to it. Once connected, configure the Conditional Split Transformation. In this blog we want to redirect any records which has Null value for ID column. The ISNULL() function can be used to find Null value rows.
 Fig 3: Write expression on Conditional Split Transformation to redirect Null records


Step 3:
Connect two Multicast Transformation to the Conditional Split Transformation, One Output NullRecords will be connect to one Multicast and default Output to second Multicast Transformation.
Add the Data Viewer between Conditional Split Transformation and Multicast Transformations to see the output.
Fig 4: Rows with Null values redirected by using Conditional Split Transformation in SSIS Package

4 comments:

  1. If you’re interested in plasma cutters, you may have noticed their range has been increasing in new technology and spreading out in price. We’ve seen this and thought it would be helpful to try to bring some detailed insight into the differences weldlover.

    ReplyDelete
  2. Music has been used as a therapy tool by doctors for several years. Relaxation music allegedly distracts patients from their pain and helps them calm down in troubled times. DIGITAL MARKETING CONSULTANT MANCHESTER

    ReplyDelete
  3. If you're a freelance online writer (or blogger, web designer, internet marketer, etc.), offering social media marketing to businesses is an ideal way to earn an extra four to five figures (e.g., thousands) per month pretty easily. The following is how and why. MANCHESTER SOCIAL MEDIA AGENCY

    ReplyDelete
  4. Toto is a game where you predict the outcome of a match by betting on a bookmaker on the Toto site. If you win, you will receive the money distributed according to the difference. Therefore, it is important to choose a safe playing field with high contrast. 토토사이트 안전놀이터 추천 모음 안전놀이터

    ReplyDelete