locked
SSIS Expression to handle NULLs in multiple columns RRS feed

  • Question

  • I have an OLEdb source that has some nulls, it has 50 columns and im trying to extract the rows that have NULLs to Bad data destination, the expression that I had for the conditional split is 

        ISNULL( [StudentName] ) == TRUE


    but that means I have to repeat it for all the columns that I have and I'm wondering if there's another way to handle this. especially since I have multiple tables to process. 
    Thanks
    Thursday, August 6, 2020 5:30 PM

All replies

  • Are all of 50 columns nullable in the table? When you said "... extract the rows that have NULLs ..." does it mean to list the rows with all NULLs of the 50 columns or with at least one NULL in them? You may write a sql script to handle it.

    A Fan of SSIS, SSRS and SSAS

    Thursday, August 6, 2020 9:34 PM
  • one Null in the whole table, is there anything that I can use to scan the entire table for nulls, doesn't matter which column?
    Friday, August 7, 2020 4:33 AM
  • Hi Sam Mitch,

    Hope the following link will be helpful:

      SQL: Select columns with NULL values only

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Friday, August 7, 2020 9:58 AM