Unable to use CopyData activity on WebLog files due to comment lines RRS feed

  • Question

  • I've seen a bunch of examples on how to read weblog files from Blob Storage, but they all conveniently don't have any comments in them.  CSV comments are lines beginning with '#'.  I can get around this to some degree by using skiplines, but there are cases where IIS will insert the header again in the middle of the file, which causes the copy activity to fail due to format exceptions.  I'm wondering if there's a way to specify comment character='#' which would ignore those lines.
    Wednesday, May 3, 2017 5:06 PM

All replies