SSIS OleDB or ADO.NET
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Just wondering what differences there are between these two connection methods in SSIS? We are connecting to SQL 2008 R2 databases. Is one better performing than the other? Or is one easier to use? There does seem to be certain tasks that can only use one or the other.
-
Just wondering what differences there are between these two connection methods in SSIS? We are connecting to SQL 2008 R2 databases. Is one better performing than the other? Or is one easier to use? There does seem to be certain tasks that can only use one or the other.
An ADO.net connection will use the native client classes so it is better.