How to import the data from XML to txt,or table

• raghu-935218

  SSC Eights!

  Points: 903

  More actions

  April 14, 2009 at 8:59 am

  #130112

  Hi I have XML and XSD file. how can i import data into sql Server.When i Use SSIS.Xml FIle and XSD file.I am getting an error.

  Error at Data Flow Task [XML Source [2829]]: There was an error setting up the mapping. The MinLength constraining facet is invalid - The string '' is not a valid Integer value.

  what is the problem here and how can i import this into my table

  Thanks

• Rajib Bahar

  Ten Centuries

  Points: 1007

  More actions

  April 14, 2009 at 1:22 pm

  #977578

  please post what the xml and xsd file looks like... thanks

  Rajib Bahar
  http://www.rajib-bahar.com
  http://www.twitter.com/rajib2k5
  http://www.youtube.com/icsql