Post reply

SSIS FileSystem Task Catch Error

  • April 29, 2010 at 9:48 am

    #144470

    I've a file system task that is in a foreachloop container that moves log files to archive share, obviously when I hit the log that is being used I get an error and the package fails.

    Is there a way to catch this error?

  • April 29, 2010 at 10:26 am

    #1159874

    You could capure a failure of the filesystem task by adding an Exec SQL Task and connecting it to the filesystem task and changing the precedence to failure.

    The only problem I see is that you can't see what kind of failure.

    I am not a fan of the filesystem task. I usually just use a Scipt Task, then I have much more control of what happens and what I want to report out..

    CEWII

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply