SSIS - 数据流目的地 [英] SSIS - Data Flow Destination

问题描述

我正在尝试创建一个简单的Integration Services项目。作为数据源，我选择了一个平面文件，但是我在添加和配置目标时遇到了困难。目标应该是在Oracle SQL Developer中创建的数据库。我已经尝试过
来观看不同的教程，但它根本没有帮助我。有人有经验吗？

解决方案

MartinaHi，

我是否知道您是否拥有OLEDB的Oracle提供商？ 

如果没有，请使用
Oracle Developer Tools for Visual Studio

下载ODAC（Oracle数据访问组件）。

以下链接将有所帮助。

https://www.oracle.com/technetwork/topics/dotnet/ utilsoft-086879.html？ssSourceSiteId = otnjp

https://www.inogic.com/blog/2 016/12 / steps-to-connect-ssis-to-oracle /

最好的问候，

Mona Lv

Hi, I'm trying to create a simple Integration Services project. As a data source I've chosen a flat file but I have difficulties with adding and configuring a destination. The destination should be a database created in Oracle SQL Developer. I've tried to watch different tutorials, but it didn't help me at all. Does anyone have some experience with it?

解决方案

Hi MartinaHi,

May I know if you have Oracle provider for OLEDB? 

If not ,please download ODAC(Oracle Data Access Components) with Oracle Developer Tools for Visual Studio.

The following links will be helpful.

https://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html?ssSourceSiteId=otnjp

https://www.inogic.com/blog/2016/12/steps-to-connect-ssis-to-oracle/

Best Regards,

Mona Lv

这篇关于SSIS - 数据流目的地的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！