Matt Mason has a data flow package example that looks pretty complete.

Gotta check it out.

http://blogs.msdn.com/mattm/archive/2009/01/02/api-sample-data-conversion.aspx