I have a SSIS Project where I want to "pull" data from a file that only keeps the row with the Max Date. So if Salesman 111 has 3 orders dated 01/01/2011, 02/02/2013 and 03/03/2013. I want to keep the row with Salesman 111 and date 03/03/2013. The other rows 111 01/01/2011 and 111 02/02/2012 will not be used.
The SQL Code for this being:
SELECT Salesman, MAX([Date]) AS "Max Date"
GROUP BY Salesman
So in my SSIS package I was hoping to use the Conditional Split and that is where I stumble. I see all columns and functions that can be used, but not where I can script my code.