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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-10-10 : 06:19:07
|
| Hi,I am working on a few number of complex .xml files.The idea is to place these data into the sql server 2005 database tables.I have tried to use xml source task inside a ssis package but the error is:"Error at data flow task[xml source[1]]: The xml source Adapter does not support mixed content model on complex types."Does this mean the only way I can place the xml data into the sql server tables is to use openrowset ?Are there any other methods within sql server 2005?If I can somehow pass the xml contents of the .xml files as string or text, then I can go through them in sql and pull data out, etc...Any thoughts please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-10 : 06:22:20
|
| is your xml well formed? have you given a xsd schema for validating it in xml task? |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-10-10 : 08:17:45
|
| It is complicated xml file.Yes, the xsd is generated too and being used. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-10 : 09:28:32
|
| you've some methods given here toohttp://msdn.microsoft.com/en-us/library/ms191184.aspx |
|
|
|
|
|
|
xml to tables