SQL Data Generator will not do what you want out of the box but please see the following article:
http://www.simple-talk.com/content/arti ... rticle=697
which explains how to use the IronRuby generator to manipulate data. Specifically, please see the example of using conditional logis in that article:
title = table.row(\"Title\")
if(title == \"Mr\")
elsif(title == \"Miss\" or title == “Ms”)
You can use the NamesFirstMale.xml and NamesFirstFemale.xml files in the above code to specify male or female names in a specific column base on gender.
Let me know if this is what you need.