Re: DTS and ftp

From: Dave (dave_at_nospam.ru)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 14:02:38 -0800

Dumb question but what is a "DTS CMD task"

"Anthony Thomas" <ALThomas@kc.rr.com> wrote in message
news:epTPVFiHFHA.2356@TK2MSFTNGP12.phx.gbl...
> When you say it is executed on its own, do you mean the FTP statement or
the
> xp_cmdshell? Also, when you run it, what security context are you running
> it under? When you run it with DTS, what security context are you running
> it under?
>
> You could also consider using the DTS CMD task.
>
> Sincerely,
>
>
> Anthony Thomas
>
>
> --
>
> "Dave" <dave@nospam.ru> wrote in message
> news:Oct5O7dHFHA.1176@TK2MSFTNGP12.phx.gbl...
> I am trying to ftp put a file to an internet location from a DTS package.
>
> Since I am trying to send a file rather than receive it, I cannot use the
> FTP Task object. Instead, I use a SQL Task object with something like
this
>
> EXEC master..xp_cmdshell
> 'ftp -s:C:\SQLFiles\Export\FH_Feed\fh_ftp.bat'
>
> When executed on its own, the fh_ftp.bat successfully uploads (puts) the
> file. But when called from DTS nothing happens. The task reports to have
> completed sucessfully but no upload is made.
>
> What am I doing wrong?
>
>