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.

To review the document, please download the Extending SSIS Capabilities by Creating Custom SSIS Components for SharePoint Word document.

Ask a question in the SQL Server Forums

Send Feedback