From: thomas on
Dear experts,

I just migrate sql server 2000 dts to sql server 2008 Legacy DTS
I can run MANUALLY those dts smoothly in sql server 2008 Legacy.

But when i try to run the same dts in SQL Server 2008 Agent's Scheduled
Job...it prompts failure " Process Exit Code 1" for one of my bat script in
dts:

copy /y C:\abc.src c:\def.doc

(this .bat is very simple as it:)


Error Message:

........................= 0; ProgressCount = 12000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_2; 13000 Rows have been transf... Process Exit Code
1. The step failed.



Anything error in my .bat? Could anyone help me on this?
Thanks.




From: thomas on
oh..I found that seems it is mapping drive problem

It works when i type
copy /y \\server\folder\abc.src \\server\folder\def.doc

not works when i type
copy /y E:\abc.src E:\def.doc


how i can set the mapping drive works universally in whole sql server 2008?
(as i already auto mapping drive when user login windows)

Thanks.

"thomas" <thomas(a)mail.com> wrote in message
news:eMT93vLALHA.1888(a)TK2MSFTNGP05.phx.gbl...
> Dear experts,
>
> I just migrate sql server 2000 dts to sql server 2008 Legacy DTS
> I can run MANUALLY those dts smoothly in sql server 2008 Legacy.
>
> But when i try to run the same dts in SQL Server 2008 Agent's Scheduled
> Job...it prompts failure " Process Exit Code 1" for one of my bat script
> in dts:
>
> copy /y C:\abc.src c:\def.doc
>
> (this .bat is very simple as it:)
>
>
> Error Message:
>
> .......................= 0; ProgressCount = 12000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_2; 13000 Rows have been transf... Process Exit
> Code 1. The step failed.
>
>
>
> Anything error in my .bat? Could anyone help me on this?
> Thanks.
>
>
>
>


From: John Bell on
On Mon, 31 May 2010 20:33:44 +0800, "thomas" <thomas(a)mail.com> wrote:

>oh..I found that seems it is mapping drive problem
>
>It works when i type
> copy /y \\server\folder\abc.src \\server\folder\def.doc
>
>not works when i type
> copy /y E:\abc.src E:\def.doc
>
>
>how i can set the mapping drive works universally in whole sql server 2008?
>(as i already auto mapping drive when user login windows)
>
>Thanks.
>
>"thomas" <thomas(a)mail.com> wrote in message
>news:eMT93vLALHA.1888(a)TK2MSFTNGP05.phx.gbl...
>> Dear experts,
>>
>> I just migrate sql server 2000 dts to sql server 2008 Legacy DTS
>> I can run MANUALLY those dts smoothly in sql server 2008 Legacy.
>>
>> But when i try to run the same dts in SQL Server 2008 Agent's Scheduled
>> Job...it prompts failure " Process Exit Code 1" for one of my bat script
>> in dts:
>>
>> copy /y C:\abc.src c:\def.doc
>>
>> (this .bat is very simple as it:)
>>
>>
>> Error Message:
>>
>> .......................= 0; ProgressCount = 12000 DTSRun OnProgress:
>> DTSStep_DTSDataPumpTask_2; 13000 Rows have been transf... Process Exit
>> Code 1. The step failed.
>>
>>
>>
>> Anything error in my .bat? Could anyone help me on this?
>> Thanks.
>>
>>
>>
>>
>

You should use UNC paths and not rely on login specific drive
mappings.

John