List Destination Slow

Nov 25, 2011 at 9:18 AM
Edited Nov 25, 2011 at 9:18 AM


i have a excel file with more than 50.000 lines. when I send this rows to list destination , my package execute in more than 8 hours! 

have any change in my package for this to be faster? I only have 3 steps in the package: load Excel, a data conversion and destination sharepoint. the first two steps are performed in seconds.


Nov 27, 2011 at 8:19 AM

8 Hours? Entirely dependent on the amount of data you're sending, and also if there are event handlers on the list causing it to slow down per row.  There is a batch size you can always try adjusting to send bigger chunks at a time.

I've loaded 30-50k rows of data in minutes during a demo, but the rows did not have a lot of columns.