Hi,
Here is a good web site to start , check the tutorials... you will have a
better idea how to buil dts pkgs.
http://www.sqldts.com/default.aspx?277
Also is a good book in amazon.
Microsoft SQL Server 2000 Data Transformation Services DTS
By Timothy Peterson


JFB

"monalisa" <sjain (AT) recruitmax (DOT) com> wrote

I will be loading data into our tables from clients DB
using DTS. I am new at this and needed some direction on
some of the requirements I have listed below

1. If any table(client) is empty, terminate the
process and send an email about failure.

2. Process each row in the clientstable:

· If a matching row doesn't exist in any of my
tables, add a row.

· If a matching row exists in my tables but the
data differs, update the data. This process updates my
tables that contain columns that may have been updated
manually by HR personnel. Therefore, the process should
not alter data in columns other than the columns being
populated by the client tables so as not to wipe out the
manually entered data.

· If a row does not exist in the client table and
does exist in my table, mark the row inactive.

thanks