Unable To Open BCP format file

William Chuong Tran 1 Reputation point
2021-03-04T10:17:04.783+00:00

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

74311-untitled.jpg

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.
12,653 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,551 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.8K Reputation points MVP
    2021-03-04T22:44:28.473+00:00

    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 21,081 Reputation points Microsoft Vendor
    2021-03-05T07:11:47.49+00:00

    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