• Actually if data file is unicode and I use -F option let say -F2 everything is ok, no error:

    exec xp_cmdshell 'bcp AdventureWorks2012.dbo.myTable in D:\Test\MyTableData.dat -S instance\SERVER -T -F2 -f D:\Test\MyTableFormatFile.fmt'

    ?!?