DSXchange

Craig's idea looks to be simplest. You can also read the sql into the parameter and loop it so each sql reads the data and loads it to the file. This approach may be good if you wanted the sqls to be loaded to the seperate file instead of same file.

Bit Datatype can accept 0 or 1. You can probably check the data in the varchar field. If its 0 / 'T' (representing True) then you can probably hardcode 0 else 1.

@OUTROWNUM can be used in transformer to get the number of records coming out of the link.