.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Connection Managers available in SSIS - SQL Server Integration Services (SSIS) - Part 55

Posted By:Karthikeyan Anbarasan       Posted Date: May 14, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

This article is about the various connection managers available in Server Integration Services (SSIS) packaging and the purpose of each transformation
 

 

Introduction:


This article is about the various connection managers available in SSIS packaging and the purpose of each transformation. We have 17 different connection managers across the SSIS packaging in order to use it for different purposes.


You can also read my other articles on SSIS from Here

List of Connection Managers:


 

S No Name Short Description
1 ADO Used to connect to ActiveX Data Objects (ADO) objects, like a recordset.
2 ADO.NET Used to access data sources by using a .NET provider and Microsoft SQL Server and XML
3 Cache Used to read data from the cached server or from a cache file(.caw) so that the data is stored in the memory.
4 Excel Used to connect to an existing Microsoft Excel workbook file for both Source and Destination processing of package
5 File Used to connect to an existing file or to create a new file and use as a source or a destination.
6 FlatFile Used to connect to a Flat file which acts like a source or a destination for the package to access and process the data across the platform.
7 FTP Used to connect to a File Transfer Protocol Server to fetch the data or to update the data to the server.
8 HTTP Used to access the webserver using the Hyper text transfer protocol to send and receive files across the servers
9 MSMQ Used to connect to the Microsoft Message queuing server to access the messages as a source or to update the message as a destination
10 MultiFile Used to reference to the existing file or folders or to create a new file and use it as a reference at runtime.
11 MultiFlatFile Used to access the file using the flat file as multiple data source like using inside a loop container to loop through the file and access the data
12 OLEDB Used to connect to the different data source using the OLEDB provider specifically used to connect to Microsoft SQL Server.
13 ODBC Used to connect to different relational database system using the open connectivity provider
14 SMOServer Used to connect to a SQL Management server objects to access for as a source or to update as a destination
15 SMTP Used to connect to a Simple Mail transfer Protocol server to access and send mail or to receive mails
16 SQL Compact Used to connect to SQL Server Compact database for light weight accessing of the server.
17 WMI Used to connect to the Windows Management Instrumentation (WMI) in order to connect to the enterprise server for management.


Conclusion:


So in this article we have seen about the various connection managers used in the SSIS Packaging.

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend