I need to write to the error log when there is an error
row against target db, e.g. constraint violation, of my
DTS job, and to keep loading for the rest of the rows.
Are I tell my target db which rows it failed but continue
to load?

When are my options to handle exceptions?

Are there good samples out there to handle exceptions?
Can my exception event driven?

Thanks.

If you look at the Options tab of the Transform Data Task properties, you
see you specify where to log the errors that occur during the
transformation. You can also set the number of errors to allow before
failure.

Exception handling dependent very much on what kind of exceptions you have.
In general the target should be that your DTS package can handle all data
that it has to import. I assume you have some kind of specification, even if
it is incomplete, for the data that you are importing?

--
Jacco Schalkwijk
SQL Server MVP


"C TO" <anonymous (AT) discussions (DOT) microsoft.com> wrote