How to increase the Data Flow Task Plus buffer size?
To increase the Data Flow Task buffer size please complete the following steps:
1) Right-click on the Data Flow Task and select Properties.
2) On the Data Flow Task's Properties screen under Misc find fields: DefaultBufferSize and DefaultBufferMaxRows. (Please look at the screenshot below)
3) Then set up these fields to their desired value. Example: DefaultBufferSize=30000000 and DefaultBufferMaxRows=25000
Screenshot:
