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?
Check the following article... How to import XML into SQL Server with the XML Bulk Load component http://support.microsoft.com/kb/316005 Microsoft SQL Server 9.0 Technical Articles XML Support in Microsoft SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms345117.aspx http://www.15seconds.com/issue/050803.htm