BCP may work well.

If you use SSIS, I think there are some parameters to set batch size that can help, instead of trying to export all at once.