In OLE DB destination, if we are using FastLoad mode and keep "FastLoadMaxInsertCommitSize" as default(2147483647), the data will be committed in one transaction.
DefaultBufferMaxRows is to define the maximum number of rows in each buffer. Only when we can FastLoadMaxInsertCommitSize to be 0, we need to increase both the DefaultBufferMaxRows and DefaultBufferSize. FastLoadMaxInsertCommitSize equal to 0 means
the OLE DB commit data after every buffer. That is why need to increase the buffer size and rows.
Marked as answer bydanisroyi2Monday, July 28, 2014 10:31 AM
Unmarked as answer bydanisroyi2Tuesday, July 29, 2014 12:50 PM
Marked as answer bydanisroyi2Tuesday, July 29, 2014 12:52 PM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.