OLEDB Vs ODBC in SQL server dts/job

I need to update data from SQL server(our database) to Oracle
database(Target system's Database).
I am using Data Driven Query Task and parameterized Update Query in SQL
Server DTS.

Case1:
when I am using "Oracle provider for OLEDB" as connection object to
Oracle database

In DTS package on Queries tab I am getting this error :
---------------------------
Package Error
Error Source : OraOLEDB
Error Description : Provider cannot derive parameter information and
SetParameterInfo has not been called.
---------------------------
Case2:
when I am using "Microsoft ODBC Driver for Oracle" as connection
object to Oracle database.

DTS package runs successfully but corressponding Job calling this DTS
gives error as:
------------------------------------------
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSDataDrivenQueryTask_1 DTSRun OnError:
DTSStep_DTSDataDrivenQueryTask_1, Error = -2147008507 (80074005)
Error string: Unspecified error Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts.hlp
Help context: 1100 Error Detail Records: Error: -2147008507
(80074005); Provider Error: 0 (0) Error string: Unspecified
error Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.hlp Help context: 1100
Error: -2147467259 (80004005); Provider Error: 0 (0) Error
string: [Microsoft][ODBC driver for Oracle][Oracle] Error source:
Microsoft OLE DB Provider for ODBC Drivers Help file: Help
context: 0 DTSRun OnFinish: DTSStep_DTSDataDrivenQueryTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step
failed.
-----------------------------------------

Please suggest for solution so that I can run my Job calling DTS
package successfully

Regards
Archana

.

Relevant Pages