改成varchar后,原来的error message没了,可是有来了如下error: Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature. Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature. Msg 4832, Level 16, State 1, Line 1 Bulk load: An unexpected end of file was encountered in the data file. Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". 我是刚开始学sql的小菜鸟...
【在 i****a 的大作中提到】 : Have you tried creating the table as varchar? : : [发表自未名空间手机版 - m.mitbbs.com]
z*f
12 楼
Blood test can show you have the antibody. Ask your PCP to write a blood test order. Civil Surgeon accepts it.
【在 t*****t 的大作中提到】 : 问题是我知道我打过了,却没有记录。。。
i*a
13 楼
are you using bulk insert SQL command? try using a format file. or use import/export wizard (or SSIS)
will will The
【在 G********7 的大作中提到】 : 改成varchar后,原来的error message没了,可是有来了如下error: : Bulk load: DataFileType was incorrectly specified as char. DataFileType will : be assumed to be widechar because the data file has a Unicode signature. : Bulk load: DataFileType was incorrectly specified as char. DataFileType will : be assumed to be widechar because the data file has a Unicode signature. : Msg 4832, Level 16, State 1, Line 1 : Bulk load: An unexpected end of file was encountered in the data file. : Msg 7399, Level 16, State 1, Line 1 : The OLE DB provider "BULK" for linked server "(null)" reported an error. The : provider did not give any information about the error.