Error 0xc0202044: Data Flow Task:

• ramu.guggilla

  SSC Eights!

  Points: 829

  More actions

  May 30, 2008 at 5:21 am

  #380830

  Hi Folks,

  when i am trying to copy the data from the oracle database to ms-sql server 2005 i am getting the error - Error 0xc0202044: Data Flow Task: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_GUID" for "APPOINTMENT_ID".

  Actually i changed the data type to uniqueidentifier (GUID) for the column "APPOINTMENT_ID" But in the oracle the data type is int.

  I am migrating the database from oracle to sql 2005. In sql 2005 i changed data types for few columns and added relations. now i want to copy the data only from oracle to ms-sql server 2005 without losing the relations and datatypes.

  please let me know is there any way to copy the data.

  thanks in advance.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  May 30, 2008 at 6:07 am

  #822243

  You cannot put an integer into a GUID field.