SSIS Tutorial - How to Filter Rows with Null Values in Data Flow Task in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to convert blank values into Null values in Flat file source in SSIS Package. The second part of the video explain how to filter the rows with Null values by using Conditional Split Transformation. The video also explains how to use Data Viewer in Data Flow during debugging your SQL Server Integration Services Package. The scenario covered in this video is real time and we often have the requirement to ignore/filter rows with null or blank values. Video also introduce you to different SSIS Functions available and specially how to use ISNULL In SSIS Package.

1 comment: