a file that runs a series of FTP commands. I created a
textfile that has a series of FTP commands in it and I
would like to know how I can use DTS to run the commands
in the batch file. To run from a command prompt,

ftp -s:filename

but how from dts and using what object or process?

Use execute sql task and use th extended stored procedure, xp_cmdshell to invoke the command prompt...

hth

----- James Johnson wrote: -----

a file that runs a series of FTP commands. I created a
textfile that has a series of FTP commands in it and I
would like to know how I can use DTS to run the commands
in the batch file. To run from a command prompt,

ftp -s:filename

but how from dts and using what object or process?

When I use cmd to execute this:
ftp -s:c:\mytest\ftp.txt
it works fine, but when I try this:

use master
EXEC master..xp_cmdshell 'ftp -s:c:\myTest\ftp.txt'

It looks like it works, but no file is in the directory.

ANy suggestions.

Have a look at the ExecuteProcess task

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"James Johnson" <anonymous (AT) discussions (DOT) microsoft.com> wrote