Hi,
I am building in a data mart using SQL server DTS. I have
confusion that

Example

Suppose we have text file for Cust table. It has 3
customers
A,
B,
C
This information comes in text file from legacy system.
We load this data in cust table in staging.

Now we get a new text file with 5 customers i.e
A,
B,
C,
D,
E.

What query shall I write to include the 2 new customers
i.e D & E in my Staging Table. How will I refer to text
file. Meaning that

select new_customers
from text file (what shall I write here to refer my text
file).

Or how is done.

If some one can solve this simple puzzle it will be great
help.

Thanks

Steve

Hi,
easiest way is just delete old table and then load all.
I think you have every customer in text file not just new
ones. if you have only new customer you could use append
of course.
rgds
Kari