[resolved] (Resolved) Content is not allowed in prolog
Hello, I am trying to import a large excel file into database. As the first step, I created a xml metadata to grab a root of the xml file. The tXMLInput outputs a root element as a document type then with tXMLMap some elements are mapped to database. However, I just wanted to see the contents first so I put the tLogRow instead of tMSSQLoutput. When running the job, I noticed it shows 0 records is transferred and the job was appears to be ended without any error. However, when looking thru the log, I found the following error message: Error on line 3 of document : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog. After some research about the error, I did a couple of things to fix the error such as removing any character before the first tag, copying entire contents to notepad. Neither didn't work for me and I am still getting the same error message. Any idea?