Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2009-08-03 : 12:02:56
|
| How do I get an XML file transformed into the relevant columns in one or more tables? I'm no expert in the datatype. How hard can it be? Just a load of text tags where each string maps to either a column name or it's contents?I think a good candidate file to practice with would be an iTunes file, as I know what it represents - music categorisation and file locations... It's 10.7 MbWhen I import this as a flat file to put into a new table, I start by seeing only one column. How should I address this? I tried text qualifier <> |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-13 : 10:48:00
|
| In a Data flow task:Use the "XML Source" from the Data Flow SourcesSelect the location of your xml fileThen select "Generate XSD". This will allow you to map the data definition in the xml file into a tables columns. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-08-22 : 08:05:10
|
| Do you have a suggestion, after I get this error:TITLE: Microsoft Visual Studio------------------------------For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.------------------------------BUTTONS:OK------------------------------ |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-24 : 06:17:52
|
| I've not come across this one before. But it seems to be either a resource or security issue:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1be6ab1c-7c89-4dc5-8474-f7d0770431f0 |
|
|
|
|
|
|
XML Import