As per the other comments it easier to maintain the SQL code than SSIS derivation task and probably better to push the load onto the SQL server.

I know this example...

I've previously used the LAG function in SAS which is very useful. Glad to see this functionality has been added to SQL. In the BI/data warehouse environment there is often...