tags:

views:

36

answers:

1
Q: 

Exception handling in FTP task of SSIS

Hi,

I have a FTP task in my SSIS package which deletes files from FTP location. But the issue is that if the file(s) or directory is not available on the server, the task gets failed.

Is there any way that I can fix this issue?

Thanks

looking forward for urgent reply.

A: 

That is the expected behavior. The task should fail and then you should do something detecting the failure. This logic can be executed on the task failure event or by drawing the red arrow to some error handling logic from the FTP task.

Faiz  2010-09-27 10:14:30
I am now using the blue arrow to move to next task, by doing so even if the task fails, it moves to next task, but now the issue, is if the task fails due to some other reason i.e. of not finding the specified file/folder, the task will still move on. Any way I can come to know that what was the cause of failure.
kaibuki  2010-09-27 11:32:36
You can write a script for the event handler to examine the error and take corrective measures accordingly, I guess...
Faiz  2010-09-27 13:23:00

related questions

How do I delete old files from a directory while keeping the most recent ones on Windows
Wait until file is unlocked in .Net
In Python, how do I get the path and name of the file that is currently executing?
fprintf return success but can't write to an existin file
How to implement a file download in asp.net
get file version in powershell
Cannot delete, a file with that name may already exist.
Find number of files in all subdirectories
Do you have any recommended File templates for resharper for VB.Net
Hooking my program with windows explorer's rename event
Database query representation impersonating file on Windows share?
About File permissions in C#
Implementing a log watcher
Differences between unix and windows files
What is the best way to rename (move) file system branches in .NET?
Is FindFirstChangeNotification the best API to use for file system change notification on windows?
How do you get a directory listing in C?
How do you determine the size of a file in C?
How do you open a file in C++?
Binary patch-generation in C#
FileHelpers performance
How do I use Java to read from a file that is actively being written?
Binary file layout reference
CSV File Imports in .Net
What is a better file copy alternative than the Windows default?