Excel Connection

Overview

Excel 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.

SharePoint Connection

Overview

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

Dynamics AX Connection

Overview

Dynamics AX
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

Cache 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

SharePoint Source 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

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

  • Well documented API for use by user-defined scripts.
  • Independent from the hard-coded Microsoft Dynamics CRM SDK.

Dynamics AX Source

Overview

Dynamics AX Source 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

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

Dynamics AX Destination

Overview

Dynamics AX Destination 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

Receive Mail Task The Receive Mail Task can be used to perform functions related to the reception and management of email. POP3, IMAP and Exchange email servers are supported. The task can handle email attachments as well as the emails themselves.

Pages