C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
SQL Server Integration Services (SSIS) - Connection Managers in SSIS
WhatsApp
Karthikeyan Anbarasan
12y
12.4k
0
0
100
Article
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 look into my series of article on SSIS at the url -
http://f5debug.net/all-articles/
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.
Connection Managers in SSIS
List of Connection Managers
SQL Server Integration Services
SSIS
SSIS connection managers
Up Next
Ebook Download
View all
Introducing Microsoft SQL Server 2016
Read by 11k people
Download Now!
Learn
View all
Membership not found