Post reply

Error during BCP import - Invalid column ordinal for field [X] in xml format file. No spaces in column name. Any other ideas?

  • February 21, 2019 at 3:55 pm

    #377068

    As the subject says, I'm receiving the "invalid column ordinal" error while trying to BCP data into my database. There are no spaces in any of the column names. I suspect this has something to do with the column being a user-defined data type. The XML format file is created by BCP at the time of export. Anyone have an idea?

  • February 21, 2019 at 6:12 pm

    #2022610

    for your BCP, can you explicitly convert to varchar, so it's not a custom type on exoprt?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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