Package fails when schedule from Oracle DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • RE: SSIS (SQL Svr 2005) - Oracle Password Always Null
    ... Which task you are using to copy the table from Oracle to SQL Server? ... articles below to migrate the DTS package directly to see whether Oracle ... Upgrade from Data Transformation Services to Integration Services ...
    (microsoft.public.sqlserver.dts)
  • Re: Conditional data copy SQL Server to Oracle
    ... I need to transfer records from a SQL Server table to an 'equivalent' ... The DTS package itself can be set up to do the SQL Server -> Oracle ... Some minimal ActivX code seems ...
    (comp.databases.ms-sqlserver)
  • Re: DTS calling Oracle procedure
    ... Can someone let me know if there's a way of calling Oracle's procedure within a SQL Server DTS package please. ... The reason for this is that I need to execute the Oracle procedure to extract data from Oracle tables, then manipulate the data and dump the data into a temporary table which then get exported to SQL Server via DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Querying Oracle...
    ... Yes you need the Oracle bits on the PC/Server that runs the DTS package ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Package fails when schedule from Oracle DB
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... How could I grant access permission to Oracle DB from SQL server? ...
    (microsoft.public.sqlserver.dts)