现在需要完成一个job，需要从oracle端需要运行一段复杂的sql来获取真正的数据，这段sql包含建表更新等等一系列操作，本来是将这段TSQL变成存储过程放在oracle端 然后由SSIS来调用，但是目前由于权限问题，无法在oracle里面设置存储过程，目前只能由人手工在plsql ...

我在SSIS中创建了oracle的数据源，创建了两个不同的数据库连接，都能测试通过。创建的时候也都能预览数据。 但是在调试的时候，使用一个数据连接没有问题，换用另一个却会报错： [连接管理器“orcl.miner”] 错误: SSIS 错误代码 DTS_E_OLEDBERROR。出现 OLE DB 错误。

Attunity, Ltd., a provider of real-time data integration and event capture software, has announced the availability of the public beta release of Attunity Oracle-CDC for SSIS. The beta product is "a ...

REDMOND, Wash.--(BUSINESS WIRE)--April 6, 2006--Persistent Systems Pvt. Ltd. a leading provider of Custom Software Product Development services and a Microsoft Gold Certified Partner, today announced ...

For what it's worth, in my SSIS experience I've had much better luck with the .net providers than the OLEDB drivers (connecting to DB2 servers). I would personally persevere with the .net one.