SSIS - to read a NULL values in excel source

• gopalk32

  SSC Enthusiast

  Points: 174

  More actions

  January 11, 2013 at 11:16 pm

  #269188

  Hi,

  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.

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  January 14, 2013 at 10:16 am

  #1576986

  There 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,

  Tim

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices