This problem is a bit beyond the normal permissions problem of a scheduled
DTS package failing, when it works in the designer.

We have a DTS package that copies a file between servers in different
domains - I believe crossing domains is the source of the problem. This is
done in a batch file using the following two commands:

net use V: \\serverInOtherDomain\ShareName Pwd /user:OtherDomain\User
/persistent:No"
copy c:\test.txt V:\test.txt


The following steps result in the package executing as expected.
1. Terminal Service into SQL Server using the same domain account used by
the SQL Agent service
2. Right Click the DTS package in EM and execute

runs with no problem

The following fails
1. Schedule the package by right clicking and choosing Schedule package.
2. Execute the SQL Agent Job

the Job fails and file is not copied.


Here are some persmissions related settings
1. DTS owner is the same as SQL Agent account
2. Job owner is the same as SQL Agent account.
3. We are TS'd into the server using the SQL Agent account
4. The batch file runs when executed from the command prompt.
5. The DTS package runs when executed logged in as SQL Agent Account.
6. The SQL Job fails every time.

I've spent many hours on this, and me and our network administrator are
stumped. Does anyone have any idea what might be the problem? Should I
take this question to the Windows 2000 group?

Thanks in advance for ANY help on this

Jim Davis

Jim,

To debug this setup a new job with just that batch file. Play with
redirection switches to see the commands complains. Check whether V mapping
was in fact created by using: net use >c:\test.txt

Ilya

"Jim Davis" <jim.davis (AT) flexcar (DOT) com> wrote

Your suggestion prompted a bit more playing around and I discovered that if
I changed the drive letter mapping from V to T, it worked. Nothing that I
am aware of is using the V drive. Go figure....




"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote