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
No comments:
Post a Comment