ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have a question about the FTP Object.

I have the mask set for *.txt

With the TXT file on the FTP site

When the ftp object runs, it finds the file and downloads it to the target directory it then runs the success branch.

This is great.

But

When I remove the TXT file from the FTP site, and re-run the package.
When the ftp object runs, it says it finds 0 files and then runs the success branch.
Is this how the object is supposed to run?

I would have thought that if it found 0 files, it would be a failure.

To counter-act this I have added a check file object, but this is not really helpful as the file names will change every month. So it basically says, there are files in the destination download directory.

Is there a better way to do this?

David

>>>I would have thought that if it found 0 files, it would be a failure.

You are right it should fail. We will correct this one as well.

Mike

Having second thoughts.
If we modify the logic it would break other customer packages
The best thing to is use separate directory for downloads
Delete all files from directory using mask
Download files using mask
Check files using mask again if there are files fail the package

Hope that helps,
Mike

Mike

Thank you for you help.

That is very similar to what I am doing now.
I have a suggestion that would add functionality:
Add a selectable failure:

Keep the current failure, but add a radio button to turn on a file transfer feature that sends a true / false .
True would be files were transferred, false would be no files transferred.
Then add a object that only looks at that flag.
The new object would be attached to the failure branch.
On true make it go to success and on false make it go to failure.


Having the default set to off, would allow existing packages to not be broken.
While adding the functionality of determining if the failure was a connection failure , or that no files were transferred.

I am sure there could be other applications for this new object.

Until there is a better solution I will continue with the one I am using.

The files being transferred for our application are not huge, but moving them twice is more time consuming.

Dave

David

Can you try version 4.2.1.0 please

Changes are

"Fail when no files found" check box was added to FTP object
Works directly with SQLite now
Various Interbase/Firebird related bug fixes
Fixed bug with import of MS Access tables with spaces in names
Minor Interface Changes
Fixed FTP list command for Windows NT ftp server
Memory leaks were fixed

Mike