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]: 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?