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. |