Hi everybody!

I have a very strange problem, I have created a DTS that delete a table and
create again.

That table is located in a server running windows 2003 Enterprise x64 SP1
with Oracle 10r2

If I run the DTS works fine, no error, but If I run the DTS by schedulling I
always get this error:
ORA-12154: TNS: could not resolv servive name.

But the TNSnames is fine because in no schedule running is working fine.

The SQL Server is running in a Windows 2003 Enterprise x64 SP1, the SQL
Server is the 200 SP4 version.

Please help! It's very frustating not to know what is happening.
Thnxs in advance

Hello Carlos,

When something works manually and not when scheduled then usually we can
look to accounts and resources for the answers. have a look at this article
as I know it has many people in the past.


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



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,

I have checked the link, but when I run the DTS using the DTSRUN.exe command
got the same problem.

Also, the ower of the DTS is the local administrator, I'm going to recheck
all again..
"Allan Mitchell" wrote: