I am using DTS to move data between an OLTP DB and a Warehouse. Bothe DBs are in SQL server.

Anyone who knows how to iterate through a table and, depending on the data of a row, produce one or more rows in the output table?

Regards,
Peter