Microsoft KB Archive/244340

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

Article ID: 244340

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: BCP FORMAT FILE DTS

Keywords: kbbug kbpending KB244340

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.