Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssis null valus Expand / Collapse
Author
Message
Posted Tuesday, August 28, 2012 2:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 10:39 PM
Points: 211, Visits: 4,541
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
Posted Thursday, August 30, 2012 12:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:28 AM
Points: 13,641, Visits: 11,517
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
Posted Thursday, August 30, 2012 2:32 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:14 AM
Points: 692, Visits: 2,815
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
Posted Friday, August 31, 2012 9:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 287, Visits: 810
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 »

Add to briefcase

Permissions Expand / Collapse