如何在SSIS数据流源中设置SDE版本 [英] How do I set the SDE version in SSIS dataflow source

问题描述

我有一个GIS oracle数据库，需要在SSIS数据流任务中进行引用.理想情况下，我通常会执行以下操作(在Oracle SQL Developer中完美运行):

I have a GIS oracle database and I am needing to reference in a SSIS dataflow task. Ideally I would normally do something like this (which works perfectly in Oracle SQL Developer):

execute sde.version_util.set_current_version('SAFE.mvedits')
SELECT CAD_EVENTID
FROM SAFE.INCIDENT_POINT_MV

但是，当我尝试将其用作OLE DB数据源的SQL命令时，会抛出无效SQL"错误.

however when I try to use that as the SQL command of my OLE DB Datasource it throws me an "Invalid SQL" error.

如何在SSIS数据流任务数据源中设置SDE版本?

How do I set the SDE version in a SSIS dataflow task data source?

推荐答案

事实证明，这是通过第三方应用程序与GIS Oracle数据库进行交互的不足.在我的情况下，我们通过将更改捆绑到驻留在oracle服务器上的存储过程中并从SSIS内部调用该存储过程来解决此问题.

As it turns out this is a shortfall of interacting with GIS Oracle databases through thirdparty applications. In my situation we addressed it by just bundling the change up in a stored procedure that lives on the oracle server and invoking that stored procedure from inside SSIS.

这篇关于如何在SSIS数据流源中设置SDE版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！