Extending SSIS Capabilities by Creating Custom SSIS Components for SharePoint
SQL Server Technical Article
Writers: Arshad Ali
Technical Reviewers: Yaswant Vishwakarma
Content Publisher: Sreedhar Pelluru
Published: January 2013
Applies to: SQL Server 2008, SQL Server 2008 R2, SQL Server 2012
Summary: SQL Server Integration Services (SSIS) - a component of SQL Server - is an extensible platform for building high performance data integration (ETL - Extraction, Transformation and Loading) and workflow solutions. The extensibility part of SSIS comes from the fact that, the developers have ability to create custom components if the in-built components of it do not suffice the specific need. The platform makes it very simple to embed your own code into control flow or data flow pipeline.
This article demonstrates how to create custom SSIS components (connection manager, source component and destination component) that integrate data to/from SharePoint lists and work like any other native components of SSIS utilizing the SSIS pipeline for better performance.