I'm new to using DTS and kind of learning it on my own. I haven't been able to find a way to transform one row from the source connection into many rows in the destination connection (depending on what I've found in the data from the source row).

Is there a way to do this?

Hi, Did you ever find a way to do this? I'm having a similar issue.......

The way I ended up doing it was to use a LOOKUP function to execute an INSERT SQL statement.

I gotta believe there's a better way though.