Create multiple records from a single record in text file

[nuVBer]

I am creating a new text file from an existing one in DTS. Each record I read from the existing file needs to create 4 new records in the new text file with various changes depending on the record read. I haven't been able to determine how to write multiple records in the new file. Is the "Main = DTSTransformStat_OK" what determines the write record function? Is this concept even possible in DTS?

 

[JohnDTampaBay]

Check out this article about processing the same row more than once in DTS. Good luck!

http://www.sqldts.com/default.aspx?266

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