Re: FTP in DTS

From: San (bcsanthosh_at_yahoo.com)
Date: 09/14/04

  • Next message: Guy Dillen: "Re: 2 DTS Questions" 
    Date: Mon, 13 Sep 2004 22:11:56 -0700

    Hi Vyas,

    Thanks for your reply.
    Do you have any sample code for command line ftp commands?

    Thanks,
    San

    >-----Original Message-----
    >I've seen this before too, but don't have a workaround
    for this specific
    >issue. I simply use command line FTP commands, inside a
    batch file, and call
    >that batch file using the Execute Process task. It works
    fine for me, and is
    >compatible with SQL Server 7.0 DTS too.
    >--
    >Vyas, MVP (SQL Server)
    >http://vyaskn.tripod.com/
    >
    >
    >"San" <anonymous@discussions.microsoft.com> wrote in
    message
    >news:126901c49982$1b362cf0$a401280a@phx.gbl...
    >> Hi Folks,
    >> I am trying to use FTP task in DTS, when I try to select
    >> the internet site for source and provide an ftp site on
    my
    >> local system and try to move to next tab I get the
    >> following error message: "unable to connect to internet!
    >> please check the source site information, your username
    >> and password."
    >> I able to browse the ftp site thru ie on my system but
    it
    >> is not going thru the DTS. Does any one of you have
    faced
    >> this prblm earlier? if u know of any soln kindly let me
    >> know.
    >>
    >> Thanks in Advance,
    >> San
    >
    >
    >.
    >

  • Next message: Guy Dillen: "Re: 2 DTS Questions"

    Relevant Pages

    • Re: DTS Scripting
      ... The DTS FTP task PULLs and does not push so write a batch file using ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... I need to upload a file to a FTP site and I can't seem> to figure out how to do it. ...
      (microsoft.public.sqlserver.dts)
    • Re: FTP in DTS
      ... I simply use command line FTP commands, inside a batch file, and call ... > the internet site for source and provide an ftp site on my ...
      (microsoft.public.sqlserver.dts)
    • Re: Need a kick in the Butt on FTP from AS/400 to PC or FTP Server
      ... OVRDBF FILETOFILE ... The INPUT file is the file that has the ftp commands including the ...
      (comp.sys.ibm.as400.misc)
    • Re: How do I get an output file after running ftp in vbs?
      ... > I am relatively new to VBS and this is what my code for basic ftp sub ... > ' write ftp commands in the temporary file ... > .WriteLine user ... > My ftpCommandLog file is created but it is completely empty. ...
      (microsoft.public.scripting.vbscript)
    • How do I get an output file after running ftp in vbs?
      ... I am relatively new to VBS and this is what my code for basic ftp sub ... Set wshShell = WScript.CreateObject ... ' write ftp commands in the temporary file ... .WriteLine user ...
      (microsoft.public.scripting.vbscript)