You can use a Raw File Destination in a Data Flow Task which writes data to a .raw file on the filesystem in SQL Server native format. You can also use the same .raw file as a Raw File Source in a subsequent Data Flow Task.
There are three properties of a Data Flow task that you might want to look at:BufferTempStoragePath
- the location of files (can be multiple locations) that temporarily store buffer data that can no longer fit in memory.DefaultBufferMaxRows
- these two properties are related and while they can't increase the amount of total memory available, adjusting them can help you make optimum use of the memory that you do have. It's a bit of a black art mind! See this
TechNet link for more details.