Hi all,
I am designing a DTS package instead of SSIS.
I have a text file and already uploaded to tableA, there is a field
named NameID in tableA. The field NameID should match the NameID in
tableB and update other fields of tableA, the non-match records will
generate another exception text file.
How can i implatement this in DTS? Which task or tech?
Thanks
Micror

Have you tried a data transformation? The source connection is the SQL
server and the target is your error file. The source sql statement is
something like:

select t1.* from TableA t1 left outer join TableB t2
on t1.NameID = t2.NameID
where t2.NameID is null
--
Russel Loski, MCSD.Net