If you can find any way that you can re-engineer this process so that you do not do any sorting or grouping within SSIS and instead use the SQL Server engine, your problems will likely go away.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.