DTS and ftp

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?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?|||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?
>|||I think that the task that is meant is "Execute Process Task"
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Dave" <dave@.nospam.ru> wrote in message
news:%23FoxipqHFHA.4032@.TK2MSFTNGP12.phx.gbl...
> Dumb question but what is a "DTS CMD task"
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:epTPVFiHFHA.2356@.TK2MSFTNGP12.phx.gbl...
> the
> this
>|||Ahh... I see now. I just need to point the Win32Process to my bat (command)
file for execution.
Thanks Simon
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:%234H6VyqHFHA.580@.TK2MSFTNGP15.phx.gbl...
> I think that the task that is meant is "Execute Process Task"
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
> "Dave" <dave@.nospam.ru> wrote in message
> news:%23FoxipqHFHA.4032@.TK2MSFTNGP12.phx.gbl...
or[vbcol=seagreen]
package.[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
>|||Yea, yea, semantics. It was the idea though: Keep It Simple...<insert
whatever favorite "S" word here.>
Sincerely,
Anthony Thomas
"Dave" <dave@.nospam.ru> wrote in message
news:%23bwWTArHFHA.3612@.TK2MSFTNGP09.phx.gbl...
Ahh... I see now. I just need to point the Win32Process to my bat (command)
file for execution.
Thanks Simon
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:%234H6VyqHFHA.580@.TK2MSFTNGP15.phx.gbl...
> I think that the task that is meant is "Execute Process Task"
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
> "Dave" <dave@.nospam.ru> wrote in message
> news:%23FoxipqHFHA.4032@.TK2MSFTNGP12.phx.gbl...
or[vbcol=seagreen]
package.[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
>