What webpart are you using to display the transformation? If you are using a custom query make sure the ID column is returned in the query. If you are using just a repeater I would make sure the ID column is listed int he columns field.
You can turn on SQL debugging to see what queries are running to verify that column is returned.