DSXchange

I was trying the same sometime back and this topic helped.

viewtopic.php?t=126232&highlight=Abort+after+rows

This is for aborting the job as well as capturing the unwanted record.

ODBC stage does support transaction grouping. But that was another questions I had.... Would it be advisable to have all 50 links going into one ODBC stage. Will it open a new DB connection for every link. But yes ODBC stage will solve our problem , only if use just one stage having all links to it.

Yes, the only thing is, since we already have an existing code using DS in place, I was hoping if we could have twisted or tweaked something to achieve what we wanted, rather than re-doing everything.

Thanks Arnd.
Using stage variable in the transformer seems to be a good option to go along with - I will definitely give it a try.
Thanks so much for your inputs.