• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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
------------------------------
0
olongus
Asked:
olongus
1 Solution
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now