I notice you posted the question in the SSIS forum.
If you have a read of this page:http://stackoverflow.com/questions/18876559/ssis-convert-string-to-a-guid-when-importing-and-saving-data it will show you how to do it in SSIS.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537