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?