且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SSIS - 数据流目的地

更新时间:2022-11-05 14:30:33

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