Solved

SSIS FTP Task results

Posted on 2014-01-16
13
105 Views
Last Modified: 2016-06-02
Is these a way to get the stdout from an ftp task?  

I was working on a large file issue, and when I ran FTP at dos prompt I discovered that it was out of disk space.  If I could see the error in SSIS, it would save lots of time.
0
Comment
Question by:No1Coder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
13 Comments
 
LVL 16

Expert Comment

by:AlexPace
ID: 39787458
Do you mean the protocol-level log of the FTP session?
0
 

Author Comment

by:No1Coder
ID: 39789643
No.  I want to see the output as if I was running it from a command prompt.  Any error message, etc.  I want to put that information is a variable.
0
 
LVL 16

Expert Comment

by:AlexPace
ID: 39789941
The command prompt ftp.exe is a standalone FTP client program.  The SSIS task does not use that client for its connection.  It should, however, be able to create a log that will look something like what you might see if you ran ftp.exe in verbose mode.
0
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 

Author Comment

by:No1Coder
ID: 39789953
How do you create the log?
0
 
LVL 16

Expert Comment

by:AlexPace
ID: 39790095
I apologize I was mis-remembering a protocol-level trace log file I got by using an EXEC task to launch Robo-FTP and run a script.  That log was generated by Robo-FTP rather than by SSIS.  So I don't really know what SSIS is capable of as far as logging but I am sure it doesn't use ftp.exe because an FTP task can do Passive Mode but ftp.exe only does active mode.

So I would try setting the logging on the package itself to "verbose" mode and see if that provides enough information.  If that doesn't give you enough then you could use WireShark or other similar sniffer to log the text over the wire.  If you are more of an ftp.exe kinda guy than a WireShark kinda guy you could use an EXEC task to launch ftp.exe (1) in verbose mode and (2) pass the name of a script to run and (3) redirect output to a text file.  That should work as long as you can use Active mode.  If you need anything more than the most basic behavior then ftp.exe might not be appropriate for your needs.  WinSCP is free and has scripting that is a little better than ftp.exe and it has logging.  Robo-FTP is commercial but it has the best FTP scripting and support so it might be a good option if this is a project for work rather than for a hobby ore a favor.
0
 

Author Comment

by:No1Coder
ID: 39806316
I want to use the FTP task.  That is what it is for.  Is this just another limitation of Microsoft software, or is there a way to accomplish this?
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 39810344
0
 
LVL 16

Expert Comment

by:AlexPace
ID: 39812291
@dbaSQL - cool, I didn't know you could do that!
0
 

Author Comment

by:No1Coder
ID: 39815856
Thanks for this, however this is not exactly what I was looking for.  I really wanted the "console output" (what you would see if you connected to the same site using command line FTP command).  I was under impression that SSIS just put a wrapper around the FTP command.  Just trying to get stdout.
0
 
LVL 16

Accepted Solution

by:
AlexPace earned 500 total points
ID: 39816156
There is not an FTP command.
There is a tiny FTP client program named ftp.exe that you can use from DOS.
You can be 100% sure that SSIS does not use that program under-the-hood because it supports passive mode data channels and ftp.exe does not.
If I had to guess I would say their either wrote their own FTP client or they made a wrapper for the same functions that Internet Explorer uses.
That said, you really can use an execute process to launch ftp.exe and use it instead of the built-in FTP task...  and you really can redirect stdout from ftp.exe into a little text file that becomes your "log" of the FTP session, especially if you launch it in verbose mode.

Perhaps we don't need a log.  What is the actual problem that you are trying to solve?  If, for example, you have something that works in FileZilla but not in the FTP task the problem usually comes down to file and folder permissions...
0
 

Assisted Solution

by:No1Coder
No1Coder earned 0 total points
ID: 39816208
The problem is the ftp task was failing, and there was no indication of why.  I discovered (using WSFTP) that the target server didn't have enough disk space.  This took a long time to figure out because there is no output from the FTP task.  All I want is for the task to provide some information as to why it is failing.  The FTP command log would probably work, but seems overkill.  If it isn't available, okay.  I am over the immediate hurdle anyway.  I really have wasted more time on this than I should have.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 64
Removing SCCM 2016 4 53
SQLCMD question to have fields created as fixed length 2 36
VMware PVSCSI SQL Server 2016 AlwaysOn 2 37
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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