Just had to share.. I’m currently importing a list of about 4000 items from SharePoint into SQL Server.
I’m experimeting with moving OFF of ADP to do this.. but the performance side just kills me.
I just swear that using Access to import from Sharepoint is about TWICE as fast as SSIS. I’m currently using Pragmatic Works TaskFactory Professional, perhaps I can retest with native SSIS / SQL 2012.
I really SHOULD benchmark this with different size workloads to verify my results.