BUG: No Output from BCP when Using Format File to Reorder Columns

ID: Q244340

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56664 (SQLBUG_70)

SYMPTOMS

Format files for the Bulk Copy Program (BCP) can be edited to change the order of the columns in the output file. The order of the columns in the output file is governed by the values in 6th column in the BCP format file.

When you specify anything other then the default output order, which is the order the columns appear in the table, BCP produces no output, nor does it give an error message.

WORKAROUND

You can workaround this problem either by using View for the formatting or you can use Data Transformation Services to create the file.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: BCP FORMAT FILE DTS

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug