Thanks for you help Sean!

The first links were helpful!

I changed the source database connection to Microsoft ODBC for oracle and now I am able to refer to the global variable...

The error message is the same when I just type

select * from Oracle_table where activity_date > ?

Also, when I hit the preview button to see the result set...

Leon,

My package works when the source and destination databases are SQL Server databases. When I change the source database to an Oracle database, then the query for the source...

Sean,

I have tried it without the TO_DATE function. I still get an error. Were you able to recreate the error?

Thanks for your help!

Henok

Henok

Sean,

Here's the sql script in the source tab:

select * from Oracle_table where activity_date > TO_DATE(?, 'DD/MM/YYYY')

TO_DATE() is an oracle function that I use to format the date from the input...

Hi Sean,

Thanks very much for your quick reply. I am sorry for not getting back to you on time. Here's the problem: I am able to create...

Thanks for your reply sir,

I have a problem though. I am not allowed to tamper with the Oracle database. Here's what I did: using DTS I created...