Thursday, 22 December 2011

SSIS Connection manager

After my first posting about Microsoft BI tolls SSIS, now I am going to post my second scenario and it is connection manager. We have some clear understanding about connection manager before going to deepest point.

SSIS uses connection managers to integrate different data sources into packages. SSIS includes a wide variety of different connection managers that allow you to move data around from place to place.

Connection Manager

Handles

ADO Connection Manager

Connecting to ADO objects such as a Record set.

ADO.NET Connection Manager

Connecting to data sources through an ADO.NET provider.

Analysis Services Connection Manager

Connecting to an Analysis Services database or cube.

Excel Connection Manager

Connecting to an Excel worksheet.

File Connection Manager

Connecting to a file or folder.

Flat File Connection Manager

Connecting to delimited or fixed width flat files.

FTP Connection Manager

Connecting to an FTP data source.

HTTP Connection Manager

Connecting to an HTTP data source.

MSMQ Connection Manager

Connecting to a Microsoft Message Queue.

Multiple Files Connection Manager

Connecting to a set of files, such as all text files on a particular hard drive.

Multiple Flat Files Connection Manager

Connecting to a set of flat files.

ODBC Connection Manager

Connecting to an ODBC data source.

OLE DB Connection Manager

Connecting to an OLE DB data source.

SMO Connection Manager

Connecting to a server via SMO.

SMTP Connection Manager

Connecting to a Simple Mail Transfer Protocol server.

SQL Server Mobile Connection Manager

Connecting to a SQL Server Mobile database.

WMI Connection Manager

Connecting to Windows Management Instrumentation data.

 

To be continued …

Posted By: MR. JOYDEEP DAS

 

1 comment: