Using the Source Component

The Source Component is an SSIS data flow source component that can be used to read from endpoints. The following two pages can be configured in the Source component:

  • General
  • Columns

General Page

The General page can be used to configure the general settings for the Source component. Source

Connection Manager

A Connection Manager is required for the Source component to connect to an endpoint. A list of available connection managers will populate the drop-down.


The Query that can be chosen from the drop-down based on the connection configuration.


The Expand option provides a Field Selection button to get the required fields and filters. Field Selection

Batch Size

The Batch Size option allows you to specify how many records you want to retrieve per service call.

Note: The Batch Size option is only available if the endpoint supports it.


The Arguments can be chosen based on the metadata selected by the Field Selection.

Refresh Component Button

Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.

Expression fx Button

Click the fx button to launch SSIS Expression Editor to enable dynamic updates of the property at run time.

Generate Documentation Button

Click the Generate Documentation button to generate a Word document that describes the component's metadata including relevant mapping, and so on.


The Columns page provides metadata-related details for the Source component, based on the endpoint it is connected to and other properties previously specified in the General page. Source Component Columns

On the top left of the grid, the checkbox is used to toggle the selection of all available fields. This is a productive way to check or uncheck all available fields.

The Columns page grid consists of:

  • The checkbox column on the left allows you to specify what fields you want to read from the chosen object.
  • Field: Column that will be retrieved from the endpoint. When a field is selected you will be able to see general details.
  • Data Type: The data type of this field.