Uniccode Data trasformation from text file to a table

[okd]

I am transfering data from a text file which is in uniccode format to a table . I am getting below error.

SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

Situation :-
Text file contains Uniccode charecters. Importing that text file data to a table column varchar(8000). Length of uniccode text is more than 4000 .

How to solve this problem ? or any alternate method.

Thanks
Omprakash

[almaz]

Please specify SQL Server version