Derived Column Transformation in SSIS | SSIS Tutorial Part 12

replacenull(Column1/(Column2==0?null:Column2),0.00)

For Quiz-

Find Us On FaceBook-

[technospace]

Easily explained, Really appreciate your way of explanation to complex things . By just watching your videos i have learnt SSIS . Thanks for your effort and keep doing hard work .

[vaibhavsingh]

Great explanation! This deserve more views, likes and comments..

[saketshrivastava]

Very useful video for SSIS beginners and SQL Learning 😊

[criclover]

It's really awesome video, Great presentation..

[ayushpratapsingh]

important information for mee so thq sir

[valijoneshniyazov]

Can we use the variable from row count in execute process task(python?)

[Shankar-ziyk]

How to avoid the first_name and lastname tell us that also

[valijoneshniyazov]

replacenull(
Column1 /
( Column2==0 ?null : Column2 )
, 0.00)
I guess null should be NULL(DT_NUMERIC, «precision», «scale»)
Hate that data type is always problem!