Out on the SAP Community network there is an interesting article (with examples) by Lisa Mulchinock on how to use ODBC with DTW (Data Transfer Workbench).
Here is the link:
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/16238
