![Smile :)](./images/smilies/icon_smile.gif)
Wouldn't it be a problem if character datatypes in source and target follow different collation types ? Is there any advantage of using one over the other ?
In my implementation, all the target/staging tables use Latin1_General_BIN as collation type where as the sources use SQL_Latin1_General_CP1_CI_AS. This sometimes causes problems in user defined queries when doing the joins. (Collation conflict..)
Any one faced similar problem ?
~Xan