Flat File Source to Multiple Destinations RRS feed

  • Question

  • Hi All

    I have a flat file which has 100 rows.

    Now i want to move this flat files into 2 Different Flatfiles destination. All the even numbered roes goes to one destination and the odd numbered row goes into sec destination.

    sample I/O:

    Source File:

    Name    Place

    aaa       xxx

    bbb      yyy

    ccc      zzzz


    Destination 1 :                     Destination 2 :

    Name  place                     NAme   Place

    bbb   yyyy                        aaa       xxx

                                           ccc       zzzz




    • Changed type Todd McDermid Thursday, May 6, 2010 4:12 PM It's a Question
    Thursday, May 6, 2010 3:34 PM


  • You'll need to number the rows with a Script, or with the Row Number component.  Then you can use a Conditional Split to route the respective rows to the appropriate destinations.
    Todd McDermid's Blog Talk to me now on
    • Proposed as answer by Eric Wisdahl Thursday, May 6, 2010 7:40 PM
    • Marked as answer by Raymond-Lee Friday, May 14, 2010 7:24 AM
    Thursday, May 6, 2010 4:05 PM