如何通过SSIS更新Oracle DB表

I am trying to update two columns from a table based off of data I have in a view. I have tried a lot of things and have had no luck. Tried using OLE DB COMMAND with no luck (always got a "not all variables bound" error. I was thinking this would be easy. Does anyone have any expereince with this that could help?

我试图根据视图中的数据更新表中的两列。我尝试过很多东西但没有运气。尝试使用OLE DB COMMAND没有运气(总是得到“并非所有变量绑定”错误。我认为这很容易。有没有人对此有任何帮助?

1 个解决方案

#1

I ended up using Script Task to run UPDATE and everything works now.

我最终使用Script Task来运行UPDATE,现在一切正常。