SSIS - to read a NULL values in excel source

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS - to read a NULL values in excel source...

SSIS - to read a NULL values in excel source

Rate Topic

Display Mode

Topic Options

Author

Message

gopalk32

Posted Friday, January 11, 2013 11:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:36 AM
Points: 3, Visits: 21

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.

Post #1406310

Tim Mitchell

Posted Monday, January 14, 2013 10:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

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
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #1406834

« Prev Topic | Next Topic »

Permissions