I don't have your data, so I can't find the data type error. That SELECT probably gives a good starting point to start examining your DW source data.

HTH,

Rob