I have a one table want to transform to many table. In DTS, I was create one
source and destination connection, and I was try to do with row transfer with
my ActiveX data manipulation and some lookups. However, I only can get the
destination field from one table, how can I also insert into another table. I
have try to make insert from the lookup function that call the store
procedure. However, it couldn't keep the transaction while some DTS are
failure.

I think this is a general case for data transformation, would there anyone
have similar case can give me some information. thanks..!!