I have scenario where I have to do running total, I could achieve this by pure T-SQL or Script Task. But i want to avoid hand coding, and use ETL tools features. Is it possible and how. 

I have table balances

```
SELECT '00000001' AS [AccountNo], CONVERT(date,'20080828') AS [Date],10 AS [DailyMovement]
INTO   balances
UNION  ALL
SELECT '00000001' AS [AccountNo], CONVERT(date,'20080829') AS [Date],5 AS [DailyMovement]
UNION  ALL
SELECT '00000001' AS [AccountNo], CONVERT(date,'20080830') AS [Date],7 AS [DailyMovement]
UNION  ALL
SELECT '00000002' AS [AccountNo], CONVERT(date,'20080828') AS [Date],8 AS [DailyMovement]
UNION  ALL
SELECT '00000002' AS [AccountNo], CONVERT(date,'20080829') AS [Date],6 AS [DailyMovement]

```

I get ruuning total like this.

```
SELECT b1.[AccountNo]
,      b1.[Date]
,      b1.[DailyMovement]
,      SUM(b2.[DailyMovement]) AS [RunningTotal]
FROM   balances b1
INNER  JOIN balances b2 ON  b1.[AccountNo] = b2.[AccountNo]
                           AND b1.[Date] >= b2.[Date]
GROUP  BY b1.[AccountNo],b1.[Date],b1.[DailyMovement]; 

```

want to do this in SSIS without hand coding