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


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q244340
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 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB244340
©2002 Microsoft Corporation. All rights reserved.