SQLKnowItAll

i have done now same as you said but i am getting error.

i used \ n as row terminator as specified for last row.

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)".