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...
>> 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?
>>
>|||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...
> > 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?
> >>
> >>
> >
> >
>|||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...
> > 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?
> >>
> >>
> >
> >
>