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
 Import/Export (DTS) and Replication (2000)
 Process task

Author  Topic 

sardinka
Posting Yak Master

142 Posts

Posted - 2004-07-19 : 08:38:52
I have a simple Process task where my win32 process.value is cmd.exe
Parameters:copy \\ServerName\d$\Archive\Out\File.xls \\ServerName\d$\users\Out\ /Y
Cope file from one location to the other. when I run this line in cmd it is fine, howere when I run in dts it just hang up.Any idea why?

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-07-19 : 08:44:17
What userid is running your SQL Server? Is it a domain users, and does it have access to the drive?

It just "hangs" or fails ?

CiaO

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -