SSIS Derived Column - Equivallant to MRound in Excel

Prashant Pandey 21 Reputation points

Hello Experts,

I am new with SSIS and stuck at one requirement.

Requirement is : "0.5 day is 3 hours, full day is 6 hours. Divide hours by 6 and round up to the nearest 0.5 for days calculation.
Like 5 hours = 1 day, 7 hours =1.5 days."

In Excel we have MRound(Number,Multiplier), but nothing similar in SSIS derived column?

Any help how this can be achieved?

Thanks for your help in advance.

Prashant Pandey

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 32,506 Reputation points

    Hi @Prashant Pandey ,

    You may use ceiling function in SSIS.

    First using yourcolumn/3 in Derived Column and then use ceiling(newcolumn)/2.




    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,941 Reputation points

    Hi @Prashant Pandey ,

    You can simulate such MS Excel function in SSIS by using the SSIS Expression ROUND() function.
    For the reference: round-ssis-expression

    0 comments No comments