sql server dts: Package fails when schedule from Oracle DB -- sql server dts

Package fails when schedule from Oracle DB

Podi
5/5/2005 12:02:03 PM

sql server dts: 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

Re: Package fails when schedule from Oracle DB

Allan Mitchell
5/5/2005 8:25:37 PM

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

[quoted text, click to view]