Hello All,

I'm new to DTS and was asked to work on a task. It involves copying records
from tables of one server to
a database on another server.

This is pretty simple; however, they would want the package also to log all
errors, display a summary of
tables transferred along with the record count and email the log file.

The Typical errors that are required to logged are
[1] SQLServer does not exist or access denied
[2] Login Failed for user "Username"
[3] Invalid Database : Could not locate entry in sysdatabases for database
'Transact'. No entry found with
that name. Make sure that the name is entered correctly.
[4] SELECT permission denied on object 'Employees', database 'BEmployee',
owner 'dbo'

I'm not sure if DTS allows this type of logging. One way to address the
above would be to check for the
above errors before the actual package runs. But if this can be handled on
the fly it would be nice.

Apart from logging the above errors, it is required to also have the list of
tables transferred along with successfully
transferred number of records and number of errored records.

Table Transferred Errored
---------- ------------ -----------
Employee 23999 0
Dept 21 2
Order 874655 0
Inventory 92129778 98

I know that the number of transferred/errored records can be tracked in the
Post-Source Data Phase of
transformation.

Thanks,
rgn