Microsoft SQL Server Connectors

 

By

Name

Data Access API

Supported SQL Versions

64 bit

Metadata support

FAQ

Microsoft

SqlClient Data Provider

.NET

ALL

yes

table/view/parameter/stored procedure

<link to troubleshooting>

Microsoft

Ole DB provider for SQL Server

Ole DB

ALL

yes

table/view/parameter/stored procedure

<link to troubleshooting>

Microsoft

SQL Native Client

OLE DB

ALL

yes

table/view/parameter/stored procedure

<link to troubleshooting>

Interactive Edge

DataDefractor 

ODBC

ALL

yes

table/view/parameter/stored procedure

See website 

ETI

SQL Server BTO

Native Load and Unload


Note: This article has been ported over from http://ssis.wik.is/ 
Note: If you were the owner of above article, update it to the latest information or with other appropriate information.