SSIS Components for Excel Services

Build 20.0.7656

Getting Started

Connecting to Excel Services

Establishing a Connection shows how to authenticate to Excel Services and configure any necessary connection properties from the Connection Manager window.

You can also configure component capabilities through the available Connection properties, from data modeling to firewall traversal. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.

SSIS Version Support

The CData SSIS Components for Excel Services provide data flow components that allow for straightforward integration with Excel Services data from SSIS data flow tasks. SQL Server 2008 R2, 2012, 2014, 2016, 2017, and 2019 are supported including their corresponding version of SQL Server Data Tools.

Excel Services Version Support

The component supports retrieving Excel data from SharePoint On-Premises and SharePoint Online, through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

See Also

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656