[EZLINK] Help in DTS + Oracle data source
Dear Friends,
I am having a DTS with Microsoft ODBC driver for Oracle as data
source. I am trying to do the following with few more steps following
this.
delete from tablename where cr_date = (sysdate - ?)
I have created globalvariable and assigned a value for it and the
mapping is also done. But I get the following error when i try to
execute this step.
Error Source : Microsoft DTS package
Error Description : The task reported failure on execution.
Without parameters, if i try
delete from tablename where cr_date = (sysdate - 1), it works.
I tried changing the data source to Microsoft OLEDB driver for oracle
but it says no paramters for the sql statement.
I tried for SQL server(with parameters and with a slight change in
the query), it works.
Can any one help me in this regard.
Thanks a lot in advance.
Cheers,
Ganesh
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ezlink/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ezlink/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:ezlink-digest@yahoogroups.com
mailto:ezlink-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
ezlink-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to: