Excel Source

Overview

The Excel Source Component is an SSIS Data Flow Component for consuming data from Excel worksheets.

The component dialog contains the following elements:

Excel Destination

Overview

The Excel Destination Component is an SSIS Data Flow Component for inserting data into Microsoft Excel worksheets.

The component dialog contains the following elements:

SharePoint Destination

Overview

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


Setup

Use the parameters below to set up the component.

SMTP Connection

Overview

SMTP Connection Manager is SSIS Connection Manager for establishing connections with SMTP-enabled mail servers. Use the API to build components based on SMTP Connection Manager.


Setup

Use the SMTP Connection Manager dialog to specify properties to send mails.

POP3 Connection

Overview

POP3 Connection Manager is SSIS Connection Manager for establishing connections with POP3-enabled mail servers. Use the API to build components based on POP3 Connection Manager.


Setup

Use the POP3 Connection Manager dialog to specify properties for connecting to POP3 mail server.

IMAP Connection

Overview

IMAP Connection Manager is SSIS Connection Manager for establishing connections with IMAP-enabled mail servers. Use the API to build components based on IMAP Connection Manager.


Setup

Use the IMAP Connection Manager dialog to specify properties for connecting to IMAP mail server.

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.

Pages