DTS, 从Formatted text文件Import data

Question

http://community.csdn.net/Expert/topic/5045/5045602.xml?temp=.0278284
http://blog.csdn.net/zjcxc/archive/2004/02/13/20094.aspx

Answer 1

楼上可能没有明白我的意思DTS我会用，BCP也没有问题，问题在于文本文件内容"D03137","  ","1","ALEO SOLAR AG, OLDENBURG"
"D03137","  ","2","ALEO SOLAR AG, OLDENBURG"
"D03137","  ","3","ALEO SOLAR AG, OLDENBURG"
"D03137","  ","4","ALEO SOLAR AG, OLDENBURG"上面的内容看上去非常工整，问题在于ALEO SOLAR AG, OLDENBURG中间有一个“,”所以DTS失败

Answer 2

Sorry, for not support you directly.
It can't work in this case. But I advice you not use comma "," to divide data column.
You can use vertical "|" to do this.