Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 command in cmd

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-18 : 01:22:09

i use "Execute Process Task Properties"

in Win32 process:d:\file.bat

i get this error:

CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 2, which does not match the specified SuccessReturnCode of 0

sorry i cant success to add a file

i have this code(in bat):
net use w: \\132.13.14.23\GFT /y /USER:PL t54321 /PERSISTENT:YES

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-18 : 02:51:28
i succeed, i just put 2 in Return Code,i dony know why but it's work.
someone can explain me please?

thanks
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-18 : 03:46:20
And make sure you drop the w: connection before adding.
Otherwise you get an error if w: already exists.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-18 : 03:46:53
Buy why do you need to have a drive letter assigned to the UNC path?
Most Tasks are UNC aware.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-18 : 07:34:15
i dont think that you understand my question:

i just change number from 0 to 2 in Return Code and it's work.

why?(sorry but i dont understand your solutions)
Go to Top of Page
   

- Advertisement -