Skip to Content
May 21, 2009 at 05:03 PM

Error "Conversion failed While processing one of the dimensions"



We are getting following error when processing the one of our dimensions ? Any clue why ? and how to fix it ?

"Conversion failed when converting the nvarchar value ""to data type smallint . Object variable or with block variable not set"

Another question , During CPM311 class we been told , it is good idea to process all dimensions and optimize the application after every data load ? What you guys think about it?