SSIS集成ADO Net Destination [英] SSIS Integration ADO Net Destination

问题描述

您好，

我正在努力将SSIS从OData源集成到oracle数据库。

我创建了ODATA源连接到ADO NET Destination，执行包时我收到了以下错误

[ADO NET Destination [2]]错误：ADO NET Destination无法获取连接，并显示以下错误消息： "OCIEnvCreate失败，返回码为-1，但错误消息文本不可用。"。$
[SSIS.Pipeline]错误：ADO NET目标验证失败并返回错误代码0xC0208452。

解决方案

阅读这篇文章

https://stackoverflow.com/ questions / 18096409 / connections-to-oracle-database-using-sql-server-integration-services

/ *

你需要道琼斯指数nload"ODTwithODAC1120320_32bit.exe"的副本可以在以下网址找到：

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

* /

Hello,

I am working on integrate SSIS from OData source to oracle database.

I have created ODATA source connected to ADO NET Destination, when execute the package I have received the below errors

[ADO NET Destination [2]] Error: ADO NET Destination has failed to acquire the connection with the following error message: "OCIEnvCreate failed with return code -1 but error message text was not available.".
[SSIS.Pipeline] Error: ADO NET Destination failed validation and returned error code 0xC0208452.

解决方案

Read this article

https://stackoverflow.com/questions/18096409/connecting-to-oracle-database-using-sql-server-integration-services

/*

You need to download a copy of "ODTwithODAC1120320_32bit.exe" which can be found at:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

*/

这篇关于SSIS集成ADO Net Destination的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！