Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find greatest date in SSIS Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 5:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 7:40 AM
Points: 55, Visits: 14
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!!!
Post #1477945
Posted Friday, July 26, 2013 7:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:46 AM
Points: 13,622, Visits: 10,513
Unpivot the data and use the Aggregate transform to find the max.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478005
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse