Is there a way??

[redsand23]

Is there a way of doing this in DTS.

I want to merge 2 text files that are tab delimited and using 2 fields(Sales order & line) as the link between the files. After the merge I want to save in excel format and then send it out in an e-mail. (I have the e-mail figured out).
Any help would be greatly appreciated.

 

[JohnDTampaBay]

Anything is possible given enough time and money. I would import each file into SQL, then export to Excel using a SELECT joining the two tables together.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)