September 5, 2006 at 3:14 am
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
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
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