Hi,
My bulk load worked, however, I had some messages returned. Just
wondering what they mean' Thanks
This is my Bulk Insert stmt:
BULK INSERT dbo.[Table_Load] FROM 'c:\admin\myFile.txt' WITH
(FIELDTERMINATOR='\t',ROWTERMINATOR='\n'
,CODEPAGE = 'OEM',FIRSTROW=2)
These are the messages returned:
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.
(459 row(s) affected)Hi
If you don't specify a DATAFILETYPE then 'char' is assumed and it looks like
you have a unicode file, therefore you should specify 'widechar'. Lookup BUL
K
INSERT in Books Online for more information.
John
"tootsuite@.gmail.com" wrote:
> Hi,
> My bulk load worked, however, I had some messages returned. Just
> wondering what they mean' Thanks
> This is my Bulk Insert stmt:
> BULK INSERT dbo.[Table_Load] FROM 'c:\admin\myFile.txt' WITH
> (FIELDTERMINATOR='\t',ROWTERMINATOR='\n'
,CODEPAGE = 'OEM',FIRSTROW=2)
> These are the messages returned:
> 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.
> (459 row(s) affected)
>
No comments:
Post a Comment