SSIS 2016 read/write to SharePoint 2019 lists

• TangoVictor

  SSChampion

  Points: 10976

  More actions

  March 17, 2020 at 2:15 pm

  #3735024

  Looking for a solution to read/write sharepoint 2019 lists.

  We've been using the SharePoint components that were originally on codeplex and now on github but they haven't been touched for over 2 years.

  We use Odata and the SP list source/dest components for reading/writing lists, this is all on SP 2010.

  We are moving to SP 2019 in the next few months and need something that will work, need full CRUD for Sharepoint lists. Prefer not to purchase some third party components.

  Also using ADFS for security on 2019

  Any input would be appreciated, thanks.

   

• Martin Schoombee

  SSCoach

  Points: 19135

  More actions

  March 17, 2020 at 2:56 pm

  #3735042

  I'd recommend using Powershell, as it is much more robust than trying to do it in native SSIS tasks.