Can SQLBulkCopy be told to ignore extra columns? RRS feed

  • Question

  • is there any setting that can be specified to tell the SBC to ignore any additional columns in my XML source that do NOT exist in the DB? I have a schema in the database for exactly what I want to capture but my XML source will vary with what columns it has. It will always have columns that match those in the DB but it may also have additional nodes that do not match those in my DB.
    Tuesday, May 25, 2010 3:09 PM


All replies