Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

XML file

Posted on 2013-01-25
1
331 Views
Last Modified: 2016-02-10
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
Comment
Question by:olongus
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38820302
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question