Posted: Fri Oct 03, 2008 8:50 pm
Another Transformer solution - maintain two stage variables to determine whether you've seen "<![CDATA[" (if not you're still in the header and you don't pass this row) and another to detect when you see "</xtd:Data>" (which means you're now in the trailer and you don't pass this or any more rows). Both are initialized to @FALSE. The constraint expression is simply a combination of these two, for example Not(svInHeader) And Not(svInTrailer).