I am trying to convert a table from one schema to another and the destination table (SQL CE) contains a uniqueidentifier field. This field can accept nulls and is optional. I am not supplying any values for it.
But when I run the package it throws an error.
SQL Server Compact Destination : Data conversion failed. [ OLE DB status value (if known) = 2 ]
If I map a dummy value for this column then the error doesnt occur. Any help would be appreciated. Thanks,
[Please mark the post as answer if it answers your question]
View Complete Post