Hi

I have som dts packets that imports data from oracle into
Sql server. They work fine when i run them but when i try
to schedule them they fail.

Error = -2147467259 (80004005)
Error string: Error while trying to retrieve text for
error ORA-01019
Error source: Microsoft OLE DB Provider for Oracle

Can anyone help me???

/Maria

the 80004005 error and the fact that it works fine when executed manually
but not when scheduled leads me to think you will be experiencing this
problem.

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.konesans.com - Consultancy from the people who know


<anonymous (AT) discussions (DOT) microsoft.com> wrote

I have read the paper but I still cant get it working.
The owner of the job is 'sa' and i'm sitting at the
server. Any suggestions??

/Maria

If the owner of the job is sa then the account used by SQL Server when the
job fires is the SQL Server Agent service account.
Log in to the server as this account (hopefully not the "system Account")
and try to execute the package now.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


<anonymous (AT) discussions (DOT) microsoft.com> wrote