How to find greatest date in SSIS

  • Can anyone please help me on this?

    My requirement is,

    I have four date columns and i should consider all the four date columns and find the greatest one among them in SSIS without using Script Component task.

    Example:

    Input:

    Date1, Date2, Date3 , Date4

    01/03/2013, 03/04/2013, 08/04/2013, 07/06/2013

    Output:

    07/06/2013

    Thanks in Advance!!!

  • Unpivot the data and use the Aggregate transform to find the max.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply