ssis null valus

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » ssis null valus

ssis null valus

Rate Topic

Display Mode

Topic Options

Author

Message

asranantha

Posted Tuesday, August 28, 2012 2:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 162, Visits: 3,820

hi friends i have small doutb in ssis plz tell me how to solve this issue

how to handle nulls data ..and maintain one table in ssis without useing isnull function .

i do useing null function like isnull(col)||isnull(col2) that way i do.

but i donot i want like that way .
plz tell me how to handle null values in ssis and send to that records anothere table

Post #1350730

Koen Verbeeck

Posted Thursday, August 30, 2012 12:22 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467

You have no other choice. ISNULL is there to check a column for NULL values. You could do it in a script component or in TSQL, but in the end you'll still be doing the same thing, just with another tool.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1352021

Andy Hyslop

Posted Thursday, August 30, 2012 2:32 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 595, Visits: 2,136

All swings and roundabouts but there is always the COALESCE function...

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Post #1352052

herladygeekedness

Posted Friday, August 31, 2012 9:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:46 AM
Points: 240, Visits: 653

script component would be the only other way I'd consider, since you can have 2 outputs and shoot records out the desired pipeline.

The null check in there is slightly different but still, it's going to be ISNULL() at its heart.

Not sure why you want to overcomplicate by avoiding the most direct null check available via derived column?

Post #1352916

« Prev Topic | Next Topic »

Permissions