UsePagination
Whether or not the CData ADO.NET Provider for Microsoft Excel Online should use client side paging.
Data Type
bool
Default Value
false
Remarks
Whether or not the CData SSIS Components for Microsoft Excel Online should use client side paging. We suggest you set this to true in case of a large dataset.