unable to import a data available in a file with .txt format by using Export/Import wizard

[VijiKumara]

Hi,

I am trying to import a data which is available in a flat file(.txt)/tab-delimited, by using export/import wizard available in SQL server. Please see the error attached and provide any solution.

Thanks,
Vijay

 

[fredericofonseca]

error is quite clear - text was truncated or mismatch code page - manually do the package, ensuring that the column sizes are enough to cover the size of the incoming fields, that the correct column/row delimiter are choosen and that the code page defined on the package matches that of the destination table.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886