Is there a way to extract SharePoint lists using one generic SSIS package?

• sqlbaby2

  Ten Centuries

  Points: 1351

  More actions

  February 27, 2017 at 7:24 am

  #341078

  I need to import multiple SharePoint lists data to SQL (one for each table).

  Rather than use SSIS and have multiple Odata sources and destinations (one for each table), is there a way to have a generic package that will import all the SharePoint lists to the database ?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  February 27, 2017 at 2:21 pm

  #1930552

  sqlbaby2 - Monday, February 27, 2017 7:24 AM

  I need to import multiple SharePoint lists data to SQL (one for each table).

  Rather than use SSIS and have multiple Odata sources and destinations (one for each table), is there a way to have a generic package that will import all the SharePoint lists to the database ?

  I've seen people using different adapters and such to do so but I think it depends on your versions. Maybe this would work:
  SharePoint List Source and Destination

  Sue