BCP XML FileFormat error Invalid ordinal for field 2

• Ankit Peshwaria

  Old Hand

  Points: 358

  More actions

  October 1, 2010 at 11:22 am

  #387918

  Hi,

  When creating xml fileformat its throwing me error "invalid ordinal".

  when created non-xml file format, no error, and was also able to load data file into sql table. Not sure why bcp (Version: 10.50.1600.1) is not able to create xml file format.

  C:\>BCP "MyGDB.dbo.Items_Import" format nul -f"C:\Ankit\Temp\BCP\ItemsMaster.xml" -x -w -T -S"(Local)"

  SQLState = HY000, NativeError = 0

  Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid ordinal for field 2 in xml format file.

  Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation

  Item Numbervarcharno18 noyesnoSQL_Latin1_General_CP1_CI_AS

  Description1nvarcharno80 yes(n/a)(n/a)SQL_Latin1_General_CP1_CI_AS

  Description2nvarcharno80 yes(n/a)(n/a)SQL_Latin1_General_CP1_CI_AS

  UMvarcharno3 yesyesyesSQL_Latin1_General_CP1_CI_AS

  ~ Ankit

  Kindest Regards,
  Ankit Peshwaria

• alex69ander69

  SSC Enthusiast

  Points: 134

  More actions

  October 19, 2015 at 9:07 am

  #1834106

  Hi there,

  Take a look at https://connect.microsoft.com/SQLServer/feedback/details/715049/bcp-fails-to-create-an-xml-format-file-if-column-name-contains-a-space