I figured it out. when do imported, I chose the source table or view the one without $. that cause the problem. However, I still did not get it, why...

Thanks. I tried. There were a lots of datatype truncate error.