SSIS 2008中的ADO NET源和OLE DB源之间的区别? [英] Difference between ADO NET source and OLE DB Source in SSIS 2008?

问题描述

有人能说出SSIS 2008中ADO NET源和OLE DB源之间的区别吗?它们在任何上下文中都相同吗?

Can anyone say the Difference between ADO NET source and OLE DB Source in SSIS 2008 ?are they both same in any context ?

推荐答案

对于小型数据集，SSIS 2008中的ADO NET源和OLE DB源之间几乎没有区别.它们之间的区别在于它们与基础数据源的通信方式. OLEDB直接与OLEDB兼容源进行对话，但是ADO .NET源通过.NET提供程序进行对话. 您应该使用ADO.NET源的唯一原因是:

With small datasets there is little difference between ADO NET source and OLE DB Source in SSIS 2008. The difference between them is how they communicate with their underlying data sources. OLEDB talks directly to OLEDB compliant sources, but ADO .NET source talks through a .NET provider. The only reason you should use the ADO.NET source is:

• 没有可用的OLE DB提供程序.
• 如果您需要从脚本任务中进行数据访问.
• 如果您需要将数据源传递给自定义组件.

这篇关于SSIS 2008中的ADO NET源和OLE DB源之间的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！