CREATE TABLE [dbo].[Tab_Import]
(
[COLUMN1] [nvarchar] (4) COLLATE Danish_Norwegian_CI_AS NULL,
[COLUMN2] [nvarchar] (3) COLLATE Danish_Norwegian_CI_AS NULL,
[COLUMN3] [nvarchar] (50) COLLATE Danish_Norwegian_CI_AS NULL
) ON [PRIMARY]
GO

BULK INSERT dbo.Tab_Import
   FROM 'D:\DataImport\Tab_Import.Dat' 
   WITH (FORMATFILE = 'D:\DataImport\Tab_Import.Fmt') ;

DATAFILETYPE = 'widenative' 

10.0
3
1       SQLNCHAR            0       8       ""       1     COLUMN1            Danish_Norwegian_CI_AS
2       SQLNCHAR            0       6       ""       2     COLUMN2            Danish_Norwegian_CI_AS
3       SQLNCHAR            0       100     "\"   3     COLUMN3            Danish_Norwegian_CI_AS

Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 1, column 3 (COLUMN3).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 2, column 3 (COLUMN3).
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)".

10.0
3
1	SQLNCHAR             	0	8	""	1	    Column1	  Danish_Norwegian_CI_AS	
2	SQLNCHAR             	0	6	""	2	    Column2	  Danish_Norwegian_CI_AS
3	SQLNCHAR             	0	100	"\r\0\0"	3	Column3   Danish_Norwegian_CI_AS

	

10.0
3
1	SQLNCHAR             	0	8	""	1	    Column1	  Danish_Norwegian_CI_AS	
2	SQLNCHAR             	0	6	""	2	    Column2	  Danish_Norwegian_CI_AS
3	SQLNCHAR             	0	100	"\r\0\0"	3	Column3   Danish_Norwegian_CI_AS