Excel Connection

Overview

Excel Connection Manager is SSIS Connection Manager for processing data in Microsoft Excel workbook. Use the API to build components based on Excel Connection Manager.


Setup

Use the Excel Connection Manager dialog to specify properties for opening Excel workbook.

SharePoint Connection

Overview

SharePoint Connection Manager is SSIS Connection Manager for establishing SharePoint connections. Use the API to build components based on SharePoint Connection Manager.


Setup

Use the SharePoint Connection Manager dialog to specify parameters for connecting to SharePoint service.

Dynamics AX Connection

Overview

Dynamics AX Connection Manager is SSIS Connection Manager for establishing Dynamics AX connections. The connection manager is based on Microsoft Dynamics AX .NET Business Connector. Use the API to build components based on Dynamics AX Connection Manager.

Distributed Cache Connection

Overview

Distributed Cache Connection Manager is SSIS Connection Manager for establishing connections with Microsoft Windows Server AppFabric Cache. The connection manager is based and requires installation of Windows AppFabric client. Use the API to build components based on Distributed Cache Connection Manager.

SharePoint Source

Overview

The SharePoint Source Component is an SSIS Data Flow Component for consuming data from the SharePoint Service. The configuration parameters are provided in the standard data flow source component dialog.

Dynamics CRM Connection

Overview

This SSIS Connection Manager stores the credentials and functionality for connecting to an on premise or in-the-cloud Dynamics CRM server.

Dynamics AX Source

Overview

The Dynamics AX Source Component is an SSIS Data Flow Component for consuming data from a Dynamics AX server. The configuration parameters are provided in the standard data flow source component dialog.

Excel Task

Overview

The Excel Task is an SSIS Control Flow task for management of Excel workbooks.


Setup

Use the General page of the Excel Task Editor dialog to configure the parameters needed to process an Excel workbook.

Dynamics AX Destination

Overview

The Dynamics AX Destination Component is an SSIS Data Flow Component for loading data into a Microsoft Dynamics AX table. The configuration parameters are provided in the standard data flow destination component dialog.

Receive Mail Task

Overview

The Receive Mail Task is an SSIS Control Flow task for receiving e-mails. The task can also decrypt and verify signatures of S/MIME e-mails.

Pages