Data Source From ORACLE

Currently, I am working SSIS project that its data source from ORACLE 9i. I installed full SSIS in server and also ORACLE. So, I have three connections available in server. They are the following below.

1. Oracle Client
2. Microsoft OLE DB Provider for Oracle
3. Oracle Provider for OLE DB

The problem is the three component can not recognize parameterization and ORACLE store procedures.

Finally, I executed the store procedures by ORACLE package from command prompt (bat files). So, the command execute from SSIS package.

Ashari Imamddin

[1355 byte] By [AshariImamuddin] at [2007-12-24]