Importing SharePoint data from Access Data Projects looks much faster than using SSIS.

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.

-Aaron

This entry was posted in SQL Server and tagged . Bookmark the permalink.