dbTalk Databases Forums  

Data Source Provider Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Data Source Provider Question in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yongli
 
Posts: n/a

Default Data Source Provider Question - 08-02-2006 , 11:55 AM






My Data Sources are ALL SQL Servers. I am wondering in the Data Source
setting of my ETL project. Should I choose OLE DB Provider for SQL Server
or Native SQL Client? Are there any performance implications regarding
choosing which provider?

It seems to me Native SQL Client performs slightly better than OLE DB
Provider. Just want to hear from your opinion on this.

Thanks,

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.