SSIS

Connecting to SharePoint Lists with SSIS

SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint lists. In this post, I’ll demonstrate how to use SSIS to read from a SharePoint list using the OData source. SharePoint lists A SharePoint list is a simple collection of related…

Read More

Get Started with the For Loop Container in SSIS

SQL Server Integration Services is equipped with tasks and containers to make it easy to design and maintain the flow of ETL: which logic should be executed, when should it be executed, and how many times should it occur. Most SSIS developers are familiar with the sequence container and the For Each Loop container, which can be used to group…