Creating XSD from XML file in SSIS

• f9c882q 61644

  SSChasing Mays

  Points: 616

  More actions

  January 25, 2013 at 1:36 pm

  #269732

  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 create an XSD from the XML file but have been 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

  ------------------------------

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 26, 2013 at 4:41 am

  #1581270

  Duplicate post. Direct replies here:

  http://www.sqlservercentral.com/Forums/Topic1411923-147-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato