Post reply

BCP issue inserting nulls and zero length charecters into same row

  • May 8, 2006 at 8:33 am

    #114132

    I am trying to use the bcp solution to populate a temp db which will then be used to populate a production db. I am having an issue and recieve an error message every time a try to BCP in data to a table that contains both nulls and zero length charecters in the same row.

    Unfortunatly I need to maintain the space charecters and maintain the null charecters in the prospective columns.

    I am unable to get the bcp to handle both at the same time. It seems that the bcp is only capable of handeling one or the other.

    Does anyone have any ideas?

  • May 8, 2006 at 2:05 pm

    #636610

    I'm guessing that your data source differentiates between the two by having nothing between field delimiters for a NULL, and an empty string ("") between field delimiters for zero-length character values.

    If that's the case, can you post the format file you are currently using?

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

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