Preview SharePoint List Structure

February 3, 2014

We’re starting a new project where we're collecting data, amongst others, from SharePoint lists from the Municipality’s site.  Though the SharePoint developers recommended we import data through a web service, we found that SSIS has a component for SharePoint as a data source. We started off by downloading and installing the SSIS component for a SharePoint List Source from CodePlex as it does not come with the SSIS itself.  We added the component to our SSIS through the Tools menu >  Choose toolbox items and then chose the relevant components: I needed to predefine for our DBA the tables we...
no comments