Using DTS execute process task to run ftp.exe, how can I get the ftp log to record in a file?

Posted on 2006-03-28
Last Modified: 2007-12-19
I have some applications that use ftp to retrieve data in an SQL job.  Everything works except I can't figure out how to get ftp to log to a text file.  It can be done manually, but not when executed from an execute process task in the DTS package.  I've done this on an AS/400 many times.  I know it can be done, just don't know how.

I prepare a txt file from a vb script preceeding the execute process task.  The execute process task win32 process is: ftp.exe,  the parameters are: -s:c:\ftpCommands.txt

Where do I put the >c:\ftplog.txt redirect command to capture the log?
Question by:JayNichols
    LVL 75

    Accepted Solution

    Instead of executing ftp.exe, consider executing cmd.exe and placing the following in the parameters:
    /c "ftp.exe -s:c:\ftpCommands.txt > c:\ftplog.txt"

    Author Comment

    Thanks for the quick response.  Worked great.  It immediately showed me my problem (a file name with a space in the middle).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now