SSIS Derived Column - Equivallant to MRound in Excel

Prashant Pandey 21 Reputation points
2022-09-07T11:39:17.133+00:00

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.

Thanks
Prashant Pandey

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 32,821 Reputation points
    2022-09-08T07:30:32.093+00:00

    Hi @Prashant Pandey ,

    You may use ceiling function in SSIS.

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

    238888-untitled.png

    238972-untitled.png

    Regards，

    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
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,946 Reputation points
    2022-09-07T12:29:29.38+00:00

    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