XML file

I'm the the process of creating an ssis package to import data from xml file to a database staging table. Using the XML source file transformation, I tried to generate an XSD to create an XSD from the file but have being getting the error below.


Any help will be appreciated.

TITLE: Microsoft Visual Studio
------------------------------

'', hexadecimal value 0x02, is an invalid character. Line 6378, position 24.

------------------------------
BUTTONS:

OK
------------------------------
olongusAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this means that your XML file contains data that is not valid XML in regards to XSD ...
please post the relevant file(s)  [make sure you don't post sensitive data, though]
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.