Hi, I would create a format file by using cmd and I got the error as picture
please help to fix thanks.
Either the file path is wrong, or you don't have write permission to that folder.
Error messages from BCP are not always that crystal clear.
The version of the bcp utility (Bcp.exe) used to read a format file must be the same as, or later than the version used to create the format file. For example, SQL Server 2012 (11.x) bcp can read a version 10.0 format file, which is generated by SQL Server 2008 bcp, but SQL Server 2008 bcp cannot read a version 11.0 format file, which is generated by SQL Server 2012 (11.x) bcp. Refer to Create a Format File (SQL Server).
Did you follow the steps from this document to create format file? Please check the location of the shared folder is correct and you have read and write permission on this folder.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
9 people are following this question.