Floating FB popout byF5debug

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

 

This is part 55 of the series of article on SSIS

Introduction:

In this article we are going to see on the different 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/tutorial/ssis.aspx

[more]

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 on the different connection managers used in the SSIS Packaging.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

Cira
Cira
8/29/2013 1:51:33 PM #

What does the colour on top left on the connection manger signify. Like the connection manager has blue, purple, pink colours.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter