Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-02-15 : 12:14:39
|
| Hi DBAs,I have an SSIS package that is using the SqlClient data provider in the Connection.I didn't develop this package. Just wondering if that provider is as fast/efficient as the OLE DB provider. Which is better and why?Thanks, John |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2011-02-15 : 21:55:47
|
| Prob, not much difference, but you should find out which works the best for you.... |
 |
|
|
|
|
|
Which Provider - SqlClient or OLE DB ?