SQLServerCentral.com / SQL Server 2005 / SQL Server 2005 Integration Services / SSIS - to read a NULL values in excel source / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 15:12:38 GMT20RE: SSIS - to read a NULL values in excel sourcehttp://www.sqlservercentral.com/Forums/Topic1406310-148-1.aspxThere are a couple of different ways you can do this. Most likely the easiest way is to send the incoming data to a Conditional Split transformation, and use that conditional split to check whether the critical fields contain a non-empty string, sending any rows with blanks to a named output. Use a Row Count transformation to capture the rows sent to that output, and use a script task to check that row count value and fail the package if it is greater than zero.If you want to fail the package immediately if a blank value is found in the data, you'll probably have to use a script component, either as a source or transformation.hth,TimMon, 14 Jan 2013 10:16:47 GMTTim MitchellSSIS - to read a NULL values in excel sourcehttp://www.sqlservercentral.com/Forums/Topic1406310-148-1.aspxHi,How to read the null values from excel source while doing in the transformation or to stop the package when the particular column has null values.Fri, 11 Jan 2013 23:16:03 GMTgopalk32