SSIS Data Source Elements

SSIS is designed to extract and transform data and load this data. This is where most of its functionality is concentrated at. SSIS Data source elements play very important role in making sure all these functionality can be successfully configured and utilized.

SSIS Data Source utilizes OLE DB and ADO.NET connections to gain access to such databases as SQL Server, DB2, SSAS and Outlook. SSIS connection manager is used to set up this data sources. It allows you to select Server Name you are trying to connect. It helps you in selection of a user account for the database and selection of your target database.

Some description
Pic 1: SSIS Connection Manager

SSIS Connections created using Connection Manager do not reside within SSIS and they are often times saved within computer registries. As a result, they can be reused across multiple SSIS Packages.

Featured pages


Learn SSIS architecture, key concepts and major SSIS components. Our online tutorials teach you pl…


Learn how to develop SSIS based solutions and application. SSIS development tutorial explains SSIS…


Find out what is required to install and configure SSIS as well as what administrative task requir…