Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

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