Good Morning
I have a question.

I have a dts that export a view of sql server 2000 in a file xls.
On the server SQL there is not Office(I think is not important).

If I manually start direct the dts all steps go well.
If I schedule the dts and then start the job ,fail. Why?

The destination path is on a NOVELL disk that i map on the server like N:\

Thanks

Because of permissions. Mapped drives are user specific.

Look here

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

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"killer" <matteo.milano (AT) katamail (DOT) com> wrote

If you create dts-packages, create them on the server itself and not
from your client.
This way you avoid to have troubles with e.g. diferent mdac-levels on
server and client, ....

When you run a package from your client, it uses your client to perform
this, the package then is not run on your server !

Jobi

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> ha scritto nel messaggio
news:eeaKWK1rDHA.2380 (AT) TK2MSFTNGP09 (DOT) phx.gbl...