InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:32:51 GMT20http://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 Mitchellhttp://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