Hi folks,
Today I face a question regarding usage of OLE DB VS.
ADO.NET Connection managers in SSIS, there are some blog posts about difference
between connection providers and speed and performance of them. So I thought
that this will be helpful if I list different Control Flow Tasks and Data Flow
Components in SSIS that supports each connection manager.
There are some tasks and components that only supports one
of connection managers and there are few that supports all of them.
This comparison made on SSIS 2012:
|
Connection Managers |
||||||
OLE DB |
ADO.NET |
ODBC |
ADO |
SQL Mobile |
SMO |
||
Control Flow |
Execute SQL Task |
× |
× |
× |
× |
× |
|
Bulk Insert Task |
× |
|
|
|
|
|
|
Data Profiling Task |
|
× |
|
|
|
|
|
CDC Control Task |
|
× |
|
|
|
|
|
Transfer Tasks |
|
|
|
|
|
× |
|
|
|
|
|
|
|
|
|
Data Flow |
OLE DB Source/Destination |
× |
|
|
|
|
|
SQL Server Destination |
× |
|
|
|
|
|
|
ADO.NET Source/Destination |
|
× |
|
|
|
|
|
ODBC Source/Destination |
|
|
× |
|
|
|
|
CDC Source |
|
× |
|
|
|
|
|
Lookup Transformation |
× |
|
|
|
|
|
|
OLE DB Command |
× |
|
|
|
|
|
|
Fuzzy Lookup Transformation |
× |
|
|
|
|
|
|
Fuzzy Grouping Transformation |
× |
|
|
|
|
|
|
Term Lookup Transformation |
× |
|
|
|
|
|
|
|
|
|
|
|
|
|
|