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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 xml to tables

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?
Go to Top of Page

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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-10 : 09:28:32
you've some methods given here too

http://msdn.microsoft.com/en-us/library/ms191184.aspx
Go to Top of Page
   

- Advertisement -