Unable To Open BCP format file

William Chuong Tran 1 Reputation point

Hi, I would create a format file by using cmd and I got the error as picture


please help to fix thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,734 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 77,581 Reputation points MVP

    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.

  2. CathyJi-MSFT 20,976 Reputation points Microsoft Vendor

    Hi @William Chuong Tran ,

    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.

    0 comments No comments