I like this idea, Oracle has a similar command but their version is unfortunately structured in a way that makes it difficult (if not impossible) to code against.

But very useful in terms of loading data to a data warehouse. Not sure how useful it would be with bcp, since bcp is more of a bulk load tool than a DML or data scrubbing tool...