Hi All,

I have a small DTS package that try to get data from Oracle to SQL server.
Package runs without any issue when execute interactively, but when schedule
it fails. My guess this could be a permission issue, how can I resolve this
issue. How could I grant access permission to Oracle DB from SQL server?

Thanks

Have a look at this

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Podi" <Podi (AT) discussions (DOT) microsoft.com> wrote