I have an ole db source, I want to connect to it to a row count transformation (count how many rows were returned from db source) as well as a flat file destination to output all the rows. I was trying to connect ole db source to both row count and flat file destination in parallel, however I found one of the row is always red, i.e., only if there is a failure in ole db source, then go to that transformation. I do not want that. I want to run both tasks on success. How can I do that? I ended up connecting ole db source to row count to flat file destination. Looks like that is the only way.

Hi Prem, Unfortunately, you can only have one output from a source. However, you can use Multicast Transformation to achieve what you want. Hope this helps..Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com