Handling NULL Values in SSIS Using The Conditional Split Transformation

The conditional split is an elegant transform - it lets you split data based on various expressions you write and send it to different destination (that may in turn 'fix' the data so it can be reintegrated back into the main stream. This video uses it to illustrate handling null/not null conditions AND reading/writing the output to Excel. For thos new to SSIS expressions, drag and drop is worth doing, the expressions are case sensitive!

I am working as a system engineer in an IT company in India. My work profile includes working as a trainer in Business Intelligence space and my expertise lies in Microsoft Business Intelligence Development Studio specially in SSIS.

sankar101010 on 6/13/2010

ok

vinodkumar myakala on 6/15/2010

Nice video

Team FAB on 6/15/2010

I couldn't make out the detail of the screen, it would be better recording it with slightly higher quality

Adel on 6/15/2010

please Help me: i can not play any video in the site. with any browser

Christian Bahnsen on 6/15/2010

Nice job. It would be helpful to zoom in to better see dialog boxes, etc. Thanks.

Kris Robinett on 6/15/2010

Why Excel to Excel? I suppose it would have been quite similar as Excel to Sql.

Ranjeet Singh on 6/15/2010

Excellent!!!

Phil Rothenberg on 6/15/2010

This doesn't seem to be a practical application of the conditional split, nor is it a practical way of handling null values.

Bruce on 6/15/2010

Screen is small hard to see clearly

Greg Wax on 6/15/2010

Very clear and straightforward example

Leonard Peoples on 6/15/2010

Slick. I like it.

Faisal Lodhi on 6/15/2010

Good Job! Enjoyed the video.

stan on 6/15/2010

Screen view not clear, but a good example that can be used.

Vinod on 6/15/2010

Excellent

Chris on 6/15/2010

Good presentation, thanks

Ram on 6/15/2010

Bit fast in explenation

Ram on 6/15/2010

Bit fast in explenation

Ram on 6/15/2010

Bit fast in explenation

Tapan on 6/15/2010

Very Nice....... Keep Posting

Ibrahim Hafidh on 6/15/2010

Very good explanation especially about the conditional split output name and default output name.

MartinIsti on 6/15/2010

This is a useful way if you need to transfer it into 2 separate destinations but in case of e.g. 1 destination SQL table where you just need to have "No color" where the excel sheets contains NULL values you can use the Derived Column transformation with an if-like expression that replaces NULL-s with the "No color" string.

Anand on 6/15/2010

good

Steve Ramp on 6/15/2010

Excellent! Best I have seen, but especially pertinent to my tasks.

Naresh on 6/16/2010

nice yhanks

Naresh on 6/16/2010

nice

303F080EA9 on 6/16/2010

good

ML Stephens on 6/16/2010

I'll need to watch it a few more times to get it----But I can see so many uses for this

Kasey Wheeler on 6/16/2010

Good video

kin on 6/16/2010

i understand.

Sreedhar on 6/18/2010

Excellent Presentation

Leon on 6/20/2010

very usefull. thanks

sumit on 7/10/2010

nice about the condition in data

Anil Babu on 8/3/2010

really nice, ty

Don Gilman on 8/20/2010

Video quality, screen cropping, off. CONTENT was excellent. Wish I saw this on Monday!

Harold on 12/22/2010

Good, but too blurry.

Zev on 2/3/2011

Very clean and to the point. I like that.

Sameer on 3/24/2011

Good video

Oves khan on 6/21/2011

THANKS SQLSHARE FOR HELPING ME

Nitin Salgar on 7/29/2011

How do you handle NULL == NULL in an expression

Binod on 8/25/2011

Thanks Rachit... Its very use full to us

sarfaraz on 3/13/2012

good, but little 2 fast.