Obviously, you have unknown (NULL) values in source column, and your
destination column does not allow NULL values. You can alter the destination
table and allow NULL values in your destination column, or you can use the
ISNULL function in the source query to change the NULL value from the source
to some predefined value.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/