In this solution, You can find how to use the Row count, Percentage Sampling, Union All and data conversion transformations.
In this folder there is a package which transfor the data from Sharepoint Online to SQL Server. I used Odatasource for sharepoint online and OLE DB destination for SQL Server.