bat script in dts
in [Server Configuration]
|
From: thomas on 31 May 2010 08:22 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 31 May 2010 08:33 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 31 May 2010 13:43 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
|
Pages: 1 Prev: synchronize sql 2008 r2 Next: datetime to datetime offset |