Hi

I am using Bulk insert statement to load a delimited file in SQL Server 2012, I have created the format file programatically and I need to use Unicode character \u007 i.e BEL character as the field terminator.

Now as per my understanding, since the file created is a unicode encoded file, it is considering the format file xml format as it is in unicode. So, is there a different way of approaching this problem or am I doing something wrong here.

bcp version : 11.0

It is not exactly clear what is happening. But if you have an old style format file, the file must be in the ANSI code page; it cannot be Unicode.

Specify the terminator as "\7" or as "\7\0" if the data file is a Unicode file.