BCP XML FileFormat error Invalid ordinal for field 2

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply