It looks to me like you're trying to insert a GUID data type into a Varchar or Varchar2 data type without doing a data type conversion. Start by checking the data types of the fields involved, then do the appropriate conversion in the SELECT statement in the transfer.

Generally, you'll need to convert anything that is specific to one database platform and not the other.

The Oracle conversion document is at http://docs.oracle.com/html/B10544_01/apa.htm.

The MSDN conversion document is at http://msdn.microsoft.com/en-us/library/ms151817.aspx.