DTS FTP Task: Is it possible to get beyond the root directory of the ftp site

Hi, I have the following problem
I am trying to download files from a ftp site using FTP task in DTS. The files reside in a subfolder of the root directory but I don't see a way to get there. Any ideas how to go around this?
ThanksI don't know what version of SQL server you are using, but in 2000 the FTP task allows you to specify the directory to retrieve the file from. After you enter the id and password you can go to the 'Files' tab and navigate through the directory structure.

DTS FTP Task "Unable to connect to internet"

I created a DTS FTP task to connect to an FTP site. The problem I'm having is the folder I want to access you cannot see under the Files Tab. So if I put the ftp site/subdirectory in the FTP Site box, I get the error "Unable to connect to internet! Please check the source site information, your username and password"

If I go to the FTP site/subdirectory in IE all the files show up fine. I believe this is limitation of DTS, but I would like to hear from you all first.

To see what error I'm talking about:
Create a DTS FTP task
Use: ftp.microsoft.com/bussys/ with no username or password
Click the Files Tab

Normally you can just put the server name in, and see all the folders/files, but the way my FTP site is set up I cannot see the folder I want, I can only access it.What do you see in the Address field of the browser when you click on this site? Something like this?

ftp://<user_id>:<password>@.ftp_site.com

If this is the case then that's the reason why you can see files and folders using your browser vs. DTS package designer.

You NEED to specify user_id and password to access FTP sites unless they are set up to allow anonymous access.

Exception to it would be a setting on an FTP site where browsing is not allowed while accessing a specific file is. Consult with the FTP site admin.

DTS FTP problem

Is there any way to enter file names in the DTS FTP task even if the files are not presently there in the remote machine?I always implement FTP via t-sql e.g.
http://www.nigelrivett.net/s_ftp_PutFile.html

But in dts you can access the object model in an activex script and change the filename.

DTS and FTP Task

Is the FTP task in SQL Server one-way?
IOW can it only get files from the Internet and not put them to the
Internet?
For the source I can specify "internet" or "directory." For the
destination I can only specify "directory."
Thus, using the FTP task, it appears that I cannot put a file to an
internet destination. For this it appears I must call a batch file with the
appropriate ftp command string.
Can anyone confirm?
Hi
The FTP task is download only.
Yes you can use the command utility to do what you require or you may want
to look at:
http://www.sqldts.com/?302
John
"Dave" <dave@.nospam.ru> wrote in message
news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> Is the FTP task in SQL Server one-way?
> IOW can it only get files from the Internet and not put them to the
> Internet?
> For the source I can specify "internet" or "directory." For the
> destination I can only specify "directory."
> Thus, using the FTP task, it appears that I cannot put a file to an
> internet destination. For this it appears I must call a batch file with
> the
> appropriate ftp command string.
> Can anyone confirm?
>
>
|||Thanks John
I have a batch file that works from the command prompt but how can I execute
that as part of my DTS package?
My SQL Task in DTS has the following command:
EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
I get a message that the command executed successfully but the file is not
uploaded.
However, from a command prompt this will upload the file just fine:
C:\>ftp -s:aol_ftp2.bat
I made sure that SQL task uses the local conmnection where my file is
located.
What am I doing wrong?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> Hi
> The FTP task is download only.
> Yes you can use the command utility to do what you require or you may want
> to look at:
> http://www.sqldts.com/?302
> John
> "Dave" <dave@.nospam.ru> wrote in message
> news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
>
|||Never mind:
This works...
EXEC master..xp_cmdshell 'ftp -s:C:\aol_ftp2.bat'
"Dave" <dave@.nospam.ru> wrote in message
news:%23ipII3EHFHA.3076@.tk2msftngp13.phx.gbl...
> Thanks John
> I have a batch file that works from the command prompt but how can I
execute[vbcol=seagreen]
> that as part of my DTS package?
> My SQL Task in DTS has the following command:
> EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
> I get a message that the command executed successfully but the file is not
> uploaded.
> However, from a command prompt this will upload the file just fine:
> C:\>ftp -s:aol_ftp2.bat
> I made sure that SQL task uses the local conmnection where my file is
> located.
> What am I doing wrong?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
want[vbcol=seagreen]
with
>

DTS and FTP Task

Is the FTP task in SQL Server one-way?
IOW can it only get files from the Internet and not put them to the
Internet?
For the source I can specify "internet" or "directory." For the
destination I can only specify "directory."
Thus, using the FTP task, it appears that I cannot put a file to an
internet destination. For this it appears I must call a batch file with the
appropriate ftp command string.
Can anyone confirm?Hi
The FTP task is download only.
Yes you can use the command utility to do what you require or you may want
to look at:
http://www.sqldts.com/?302
John
"Dave" <dave@.nospam.ru> wrote in message
news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> Is the FTP task in SQL Server one-way?
> IOW can it only get files from the Internet and not put them to the
> Internet?
> For the source I can specify "internet" or "directory." For the
> destination I can only specify "directory."
> Thus, using the FTP task, it appears that I cannot put a file to an
> internet destination. For this it appears I must call a batch file with
> the
> appropriate ftp command string.
> Can anyone confirm?
>
>|||Thanks John
I have a batch file that works from the command prompt but how can I execute
that as part of my DTS package?
My SQL Task in DTS has the following command:
EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
I get a message that the command executed successfully but the file is not
uploaded.
However, from a command prompt this will upload the file just fine:
C:\>ftp -s:aol_ftp2.bat
I made sure that SQL task uses the local conmnection where my file is
located.
What am I doing wrong?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> Hi
> The FTP task is download only.
> Yes you can use the command utility to do what you require or you may want
> to look at:
> http://www.sqldts.com/?302
> John
> "Dave" <dave@.nospam.ru> wrote in message
> news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> > Is the FTP task in SQL Server one-way?
> >
> > IOW can it only get files from the Internet and not put them to the
> > Internet?
> >
> > For the source I can specify "internet" or "directory." For the
> > destination I can only specify "directory."
> >
> > Thus, using the FTP task, it appears that I cannot put a file to an
> > internet destination. For this it appears I must call a batch file with
> > the
> > appropriate ftp command string.
> >
> > Can anyone confirm?
> >
> >
> >
>|||Never mind:
This works...
EXEC master..xp_cmdshell 'ftp -s:C:\aol_ftp2.bat'
"Dave" <dave@.nospam.ru> wrote in message
news:%23ipII3EHFHA.3076@.tk2msftngp13.phx.gbl...
> Thanks John
> I have a batch file that works from the command prompt but how can I
execute
> that as part of my DTS package?
> My SQL Task in DTS has the following command:
> EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
> I get a message that the command executed successfully but the file is not
> uploaded.
> However, from a command prompt this will upload the file just fine:
> C:\>ftp -s:aol_ftp2.bat
> I made sure that SQL task uses the local conmnection where my file is
> located.
> What am I doing wrong?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > The FTP task is download only.
> >
> > Yes you can use the command utility to do what you require or you may
want
> > to look at:
> > http://www.sqldts.com/?302
> >
> > John
> >
> > "Dave" <dave@.nospam.ru> wrote in message
> > news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> > > Is the FTP task in SQL Server one-way?
> > >
> > > IOW can it only get files from the Internet and not put them to the
> > > Internet?
> > >
> > > For the source I can specify "internet" or "directory." For the
> > > destination I can only specify "directory."
> > >
> > > Thus, using the FTP task, it appears that I cannot put a file to an
> > > internet destination. For this it appears I must call a batch file
with
> > > the
> > > appropriate ftp command string.
> > >
> > > Can anyone confirm?
> > >
> > >
> > >
> >
> >
>

DTS and FTP Task

Is the FTP task in SQL Server one-way?
IOW can it only get files from the Internet and not put them to the
Internet?
For the source I can specify "internet" or "directory." For the
destination I can only specify "directory."
Thus, using the FTP task, it appears that I cannot put a file to an
internet destination. For this it appears I must call a batch file with the
appropriate ftp command string.
Can anyone confirm?Hi
The FTP task is download only.
Yes you can use the command utility to do what you require or you may want
to look at:
http://www.sqldts.com/?302
John
"Dave" <dave@.nospam.ru> wrote in message
news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> Is the FTP task in SQL Server one-way?
> IOW can it only get files from the Internet and not put them to the
> Internet?
> For the source I can specify "internet" or "directory." For the
> destination I can only specify "directory."
> Thus, using the FTP task, it appears that I cannot put a file to an
> internet destination. For this it appears I must call a batch file with
> the
> appropriate ftp command string.
> Can anyone confirm?
>
>|||Thanks John
I have a batch file that works from the command prompt but how can I execute
that as part of my DTS package?
My SQL Task in DTS has the following command:
EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
I get a message that the command executed successfully but the file is not
uploaded.
However, from a command prompt this will upload the file just fine:
C:\>ftp -s:aol_ftp2.bat
I made sure that SQL task uses the local conmnection where my file is
located.
What am I doing wrong?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> Hi
> The FTP task is download only.
> Yes you can use the command utility to do what you require or you may want
> to look at:
> http://www.sqldts.com/?302
> John
> "Dave" <dave@.nospam.ru> wrote in message
> news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
>|||Never mind:
This works...
EXEC master..xp_cmdshell 'ftp -s:C:\aol_ftp2.bat'
"Dave" <dave@.nospam.ru> wrote in message
news:%23ipII3EHFHA.3076@.tk2msftngp13.phx.gbl...
> Thanks John
> I have a batch file that works from the command prompt but how can I
execute
> that as part of my DTS package?
> My SQL Task in DTS has the following command:
> EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
> I get a message that the command executed successfully but the file is not
> uploaded.
> However, from a command prompt this will upload the file just fine:
> C:\>ftp -s:aol_ftp2.bat
> I made sure that SQL task uses the local conmnection where my file is
> located.
> What am I doing wrong?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
want[vbcol=seagreen]
with[vbcol=seagreen]
>

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...[vbcol=seagreen]
> 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
>
|||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...[vbcol=seagreen]
> 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
>

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]
>

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

DTS - FTP Task - SQL Server 2000

Hi
Could any body tell How to download files from Internet where Source file server is using SFTP (Secure FTP)?
Note: I am able to configure and download files from Internet where Source file server is configured for FTP using FTP task in DTS Package.
Thanksone option is to download a client for SFTP, create a CMD files with commands and execute under xp_cmdshell

i.e. look at PSFTP

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

simas|||Thank you for your valuable reply...Please inform me if any come across any alternatives...Thaks