1

I have a table in a sql database that I'd like to use to populate (and regularly update) a List in SharePoint. I'm the manager for the site with this List, but not the installation (which includes hundreds of other sites). I'm a developer and have access to Visual Studio 2013 with Business Intelligence added in, so I was planning to setup an SSIS package, but can't figure out the connection without buying a product from CData.

I've tried SSIS SharePoint Online List Adapters from CodePlex, but the project won't build for me. Same issue with https://sqlsrvintegrationsrv.codeplex.com/. I was hopeful with those, so maybe just need a better walk-through.

I can connect MS Access to the List using External Data > Import or Link to a SharePoint List, so I assume that this should be possible through code elsewhere, I just don't know how. I can also connect to the SQL database through Access, but don't want to have to run code in Access on a regular basis if I could just schedule an SSIS package.

Improve this question

1 Answer 1

Reset to default
1

I've used the open source list source en destination in the past, but when I search, they don't seem to be compatible with newer SQL Server versions. If you're comfortable coding, you could write your own destination connector based on the source code, but that seems like a lot of work. Maybe a simple executable and a scheduled task would do?

Otherwise I don't think there are a lot of options.

Improve this answer
5
  • I am comfortable coding, and am looking into the REST Api for SharePoint, but am running into Credentialing issues and lacking examples.
    – Gary
    Commented Aug 23, 2018 at 14:27
  • CSOM and C# might be a better approach. Are you building an SSIS component or an executable?
    – Oak3
    Commented Aug 23, 2018 at 14:46
  • I was hoping to just use a Data Flow Task in SSIS, but am open to using a Script Task, or just writing a console app.
    – Gary
    Commented Aug 23, 2018 at 15:03
  • This should get you started: c-sharpcorner.com/UploadFile/sagarp/…
    – Oak3
    Commented Aug 23, 2018 at 15:05
  • And to authenticate: sharepoint.stackexchange.com/questions/154751/…
    – Oak3
    Commented Aug 23, 2018 at 15:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.