Here's what I do. Use Enterprise manager to script your databse at jh (all tables, view, stored procs, etc). Recreate the database locally on your machine with that script. Then create your dts and save it on your machine. Use it to transfer all data over.
This of course will break if...