[EZLINK] Re: Help in DTS + Oracle data source
Dear Friends,
I had fixed this using ActiveX Scripts. But still, if you can tell me
how it can be done in other ways, that would be great.
Thanks a lot..
Cheers,
Ganesh
--- In ezlink@yahoogroups.com, "gankmur" <ganesh.murthy@...> wrote:
>
> 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: