Re: Scheduled Package Fails Copying Files Across Domains

From: Ilya Margolin (ilya_no_spam__at_unapen.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 09:01:59 -0400

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@flexcar.com> wrote in message
news:OpZq%2363mEHA.3900@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Relevant Pages