This blog post saved me from many bruises to my forehead from banging it on my desk.
http://beyondrelational.com/modules/2/blogs/66/posts/9927/fun-with-ssis-and-guids.aspx
Handling uniqueidentifier data types in SSIS is not as intuitive as it may seem. This helped me out a lot!