SSIS Data Sources and Connection Managers

Agenda

SSIS Data Sources

SSIS Connections Manager

Creating a Data SourceA Data Source is an SSIS Project object. Data sources contain connection strings that points to the databases, and you can reference them within one or more packages.

A Connection Managers is a Package level object. Connection managers contain connection strings that point to files or databases, and you can reference them within one package.

Packages can be based on data sources defined in the SSIS project, or they can bestand-alone connections within a project.

OLEDB Oracle Connection

ADO.NET Connection

Source Target

Package

Understanding a Data Source

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Server=myServer;Database=myDataBase; User ID=myUsername;Password=myPassword;

Provider=OraOLEDB.Oracle; Provider=SQLNCLI10;

Understanding a SSIS Connections (Big Picture)Flat File

Connection

FTP Connection

OLE DB Connection

MOLAP Connection

EXCEL Connection

ADO.NET Connection

SSIS Packages

Resources

Integration Services Connections- http://msdn.microsoft.com/en-us/library/ms140203.aspx

Data Source (SSIS) - http://msdn.microsoft.com/en-us/library/ms141792.aspx

PRACTICE