RE: master.dbo.xp_cmdshell is failing

From: Norman (Norman_at_discussions.microsoft.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 14:09:01 -0700

Add PRINT @cmd before the xp_cmdshell to see what the caommand is, but I think you have -s: in there twice.

"Aman" wrote:

> Please help !
>
> I run an ftp task which picks up a file from an ftp server through a package it runs fine - no errors.
>
> If I schedule the same dts or if I run the following code in query analyser it fails
>
> declare @cmd varchar(2000)
> declare @ftpcommandfile varchar(2000)
>
> --Get list of remote files
> set @ftpcommandfile = '-s:\\mathshr01\Marketing\Wr_mrktg_s\SHARED\WM_IM\Collections\Dialer\Dialer_Files\GetDialerFile.txt'
> set @cmd = 'ftp -i -s:' + @ftpcommandfile
>
> Exec master.dbo.xp_cmdshell @cmd
>
> I get the following message:
>
> output ---------------------------------------------------------------
> Error opening script file -s:\\mathshr01\Marketing\Wr_mrktg_s\SHARED\WM_IM\Collections\Dialer\Dialer_Files\GetDialerFile.txt.
>
> Transfers files to and from a computer running an FTP server service
> (sometimes called a daemon). Ftp can be used interactively.
> FTP [-v] [-d] [-i] [-n] [-g] [-s:filename] [-a] [-A] [-x:sendbuffer] [-r:recvbuffer] [-b:asyncbuffers] [-w:windowsize] [host]
>
>
>
> -v Suppresses display of remote server responses.
>
> -n Suppresses auto-login upon initial connection.
>
> -i Turns off interactive prompting during multiple file
>
> transfers.
>
> -d Enables debugging.
>
> -g Disables filename globbing (see GLOB command).
>
> -s:filename Specifies a text file containing FTP commands; the
>
> commands will automatically run after FTP starts.
>
> -a Use any local interface when binding data connection.
>
> -A login as anonymous.
>
> -x:send sockbuf Overrides the default SO_SNDBUF size of 8192.
>
> -r:recv sockbuf Overrides the default SO_RCVBUF size of 8192.
>
> -b:async count Overrides the default async count of 3
>
> -w:buffer size Overrides the default transfer buffer size of 65535.
>
> host Specifies the host name or IP address of the remote
>
> host to connect to.
> Notes:
> - mget and mput commands take y/n/q for yes/no/quit.
> - Use Control-C to abort commands.
> NULL
>