Is that u can change the Datatype of the Destination ,if so then sink both the source and destiantion datatype to same ,

IF "ID" is integer convert into the Nvarchar using Dataconversion transformation and map the converted ID to the Destination ID feild,...but the Destination table "ID" should be set to the Nvarchar.

Let me know if this worked for u