January 11, 2013 at 11:16 pm
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
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | 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