Hi,
I am using DTS to transform data from various text and excel files into
the database. This DTS will be scheduled as a job. If the DTS
encounters any error, I need to create a log file with the error
description which is customized and I do not want to use the inbuilt
error logging.
For example, I will be downloading some data for each employee from
excel, and I have an employee master in my sql server database. If
there is any foreign key violation, I need to log that error in a text
file and skip that row.

How to trap this error in DTS package and disable the default error
message which is popped up when any error is occured.