Is it true that SSIS cannot use AWE memory which means it cannot go beyond 2
gb? If that's the case then will it not make more sense to use stored
procedures for large data processing (aggregations, filtering, unions etc)
instead of using SSIS since stored procedures will then be able to make use
of additional memory?