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.
| Author |
Topic |
|
ninel
Posting Yak Master
141 Posts |
 Posted - 2006-08-25 : 12:00:58
|
| I have an xls file that is about 358 kb and contains about 1569 rows.I am using the following code:[Code]Use masterDECLARE @reult varchar(200)EXEC @result = xp_cmdshell '\\ITITPAFS02\pds\voicenet\isiti\winzip\wzzip.exe \\ititpafs01\pds\inetpub\ftproot\accumen\political \at0123.zip \\ititpafs01\pds\inetpub\ftproot\accumen\political \at0123.xls'IF (@result = 0) PRINT 'success'ELSE PRINT 'Failure'[/code]It runs longer than 9 min. I just kill it. Am I doing something wrong?Thanks,Ninel |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-25 : 12:17:54
|
| Does wzzip.exe have a GUI interface?If so, you can't run it in xp_cmdshell.CODO ERGO SUM |
 |
|
|
|
|
|
Issues with xp_cmdshell