Post reply

Event Handler Problem

  • September 5, 2006 at 3:14 am

    #119438

    hi,

    I want to add an Event Handler onError in the package. I want that when an error occurs I want the error description to be inserted in a table.

    Basically I have a table where I store diffenent ftp location,File Name,User Name Password and all required fileds. In my package I pull the file from FTP and save it to our server.

    I want a handler that catches the error description and the ftp location which has cause the error while fetching the file.

    How can this be done?

    Thanks,

    Deepesh Verma

  • September 8, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • September 10, 2006 at 11:14 am

    #659539

    Hi,

    Have you tried setting the error output on the table read in itself(rather than Event Handler). You can change the particular column that failed to 'redirect row' after which you can direct the error to another destination, eg a flat file with error rows?

  • September 11, 2006 at 7:10 am

    #659611

    Hi,

    There is nothing like columns.I want that if the file is not present on FTP then the error should be inserted in the table lets say

    FTP URL , Error , Data/Time

Viewing 4 posts - 1 through 3 (of 3 total)

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