One Star

[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?
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] (Resolved) Content is not allowed in prolog

Nevermind, Checking on "Get Node" fixed it. Let me leave this thread for others might have a similar issue.
1 REPLY
One Star

Re: [resolved] (Resolved) Content is not allowed in prolog

Nevermind, Checking on "Get Node" fixed it. Let me leave this thread for others might have a similar issue.