[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?