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,451 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 32,506 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
  1. Yitzhak Khabinsky 24,941 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 No comments