Hi!

I need some help to do the next.

I have one text file like this:

13951926-4;500
465456-8;700
13951926-4;1000
465456-8;144444
....
and i want to get this

13951926-4;1500
465456-8;145144 (group by id, and sum the values)
....

and i must not pass through a database staging (i'm trying the enhance
the performance, if i'm wrong about this (not using an staging to do
it), please let me know)

It is posible? (all the examples that a read in the web, always use an
staging)

Do i have to read the whole text file, and programing like i was in
Visual Basic? (it exist something inside DTS which does the job (lookup
or something)?)

I also don't want to use an ODBC driver for text file (again, because
the performance).

Thanks.

Yours Faithfully

Francisco Villegas