Post reply

SSIS - to read a NULL values in excel source

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply